51Testing软件测试网'z8oB(k:C2HD;b一个月第一天的SQL脚本
o"@7|Bb\p0
s VP){ e^S01Q/a6z:CFg.P/Gi0一个月第一天的SQL脚本:51Testing软件测试网0Hl2B/bP
V ^+h
51Testing软件测试网 @#H2kJ7of9f7t Select DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)51Testing软件测试网,~;Ru:ufo1]f
Qs`)O P1R| y_0G$g7\]#Pb(|0本周的星期一
)[-XzYZS%f051Testing软件测试网 LiE a:cz~ Select DATEADD(wk, DATEDIFF(wk,0,getdate()), 0)51Testing软件测试网 J+B9AvfQ
k;lEov/k~Vo0eE6v6s iC$]0一年的第一天51Testing软件测试网Fzw;Lk
51Testing软件测试网1ss5VSeN*}U Select DATEADD(yy, DATEDIFF(yy,0,getdate()), 0)
!a.q0ZP!|"jVk0
c["pq H00b0j4U&u@ A{3?0季度的第一天51Testing软件测试网/\
{(q%b9my
f2K
51Testing软件测试网9W
^u9H#aUs Select DATEADD(qq, DATEDIFF(qq,0,getdate()), 0)51Testing软件测试网;s:ePH%Xx#P
+~Z
P'M0M!Ay051Testing软件测试网T7k:r$Uk.hg当天的半夜51Testing软件测试网3XS_d4\
4zZ+WT `2ac$N0 Select DATEADD(dd, DATEDIFF(dd,0,getdate()), 0)
RKz{&yu0k0
:Y7f#a^
?b7o0lyM XHR;iT4q(P0上个月的最后一天51Testing软件测试网q9z9d*\ S~%O
51Testing软件测试网z9e9Q-Sd Select dateadd(ms,-3,DATEADD(mm, DATEDIFF(mm,0,getdate()), 0))51Testing软件测试网P(^(ov%?&wa
51Testing软件测试网k4p+e V^_ k
"Q8i q I~C'j`0)Tjz8{%zT;C8`0c8]0去年的最后一天51Testing软件测试网X In$eP
y
51Testing软件测试网~O+f)Z
a*h Select dateadd(ms,-3,DATEADD(yy, DATEDIFF(yy,0,getdate()), 0))51Testing软件测试网5N0P#s\\;d5`X\[g
ESi[:kR0l0)BxG)j$[2C$f:p0本月的最后一天
;a fl^'Ao2t-`.wW0Shp.p)c
f0 Select dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate())+1, 0))51Testing软件测试网4zI?i]Fl
51Testing软件测试网fk*C*s @)m ]-M
51Testing软件测试网K#Dz~[m,WJ本年的最后一天
&uz7Du%P
t^051Testing软件测试网h"Vu}'IN:|g Select dateadd(ms,-3,DATEADD(yy, DATEDIFF(yy,0,getdate())+1, 0))。51Testing软件测试网#G![@/c$dV
(I4o*?7Mp$]Rd9L"qX^0y#UgF}0本月的第一个星期一
D
h2{#^oN g0m00u{
s4j j1r6s1u!`"`j\0 select DATEADD(wk, DATEDIFF(wk,0,
&d:^*pGYI4h9Gd00{fv^z-L.f0 dateadd(dd,6-datepart(day,getdate()),getdate())
_"~1i'mH+]h_051Testing软件测试网a/uKx-P"Y$Vv ), 0) 51Testing软件测试网y'FF+v(\L