1 |
<BR>select datepart(weekday, '2010-02-01') -- 2 --월<BR>select datepart(weekday, '2010-02-02') -- 3 --화<BR>select datepart(weekday, '2010-02-03') -- 4 --수<BR>select datepart(weekday, '2010-02-04') -- 5 --목<BR>select datepart(weekday, '2010-02-05') -- 6 --금<BR>select datepart(weekday, '2010-02-06') -- 7 --토<BR>select datepart(weekday, '2010-02-07') -- 1 --일<BR>select datepart(weekday, '2010-02-08') -- 2 --월<BR><BR>select getdate() -- 2010-02-04 15:31:21.293<BR>select datepart(yy, getdate()), <BR> datepart(m, getdate()), datepart(d, getdate()) -- 2010 -- 2 -- 4<BR>select datepart(yy, 0), datepart(m, 0), datepart(d, 0) -- 1900 -- 1 -- 1<BR><BR>-- * SQL Server는 0을 1900년 1월 1일로 해석합니다. <BR>-- * YEAR, DAY, MONTH 함수는 <BR>---- 각각 DATEPART(dd, date), DATEPART(mm, date), DATEPART(yy, date)의 동의어<BR><BR> |
—————————————————–
날짜 부분 약어
year yy, yyyy
quarter qq, q
month mm, m
dayofyear dy, y
day dd, d
week wk, ww
weekday dw
hour hh
minute mi, n
second ss, s
millisecond ms