1 |
<BR>select datediff(day, '2010-01-01', '2010-01-10') -- 9<BR>select datediff(day, '2010-01-10', '2010-01-01') -- -9<BR>select datediff(month, '2010-01-01', '2010-03-01') -- 2<BR> |
—————————————————–
날짜 부분 약어
year yy, yyyy
quarter qq, q
month mm, m
dayofyear dy, y
day dd, d
week wk, ww
hour hh
minute mi, n
second ss, s
millisecond ms