大家帮帮忙,有day时间怎么得到week,quarter,year?

Question

update 时间表 set year=year(day),week=datename(weekday,day),datepart(qq,day)

Answer 1

update 时间表 set year=year(day),week=datepart(wk,day),quarter=datepart(qq,day)

Answer 2

DATEPART ( datepart , date ) datepart:
日期部分       缩写 
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 

Answer 3

update 时间表 set year=year(day),week=datepart(wk,day),quarter=datepart(qq,day)

Answer 4

select datename(weekday,getdate()) --星期四select datename(quarter,getdate()) --1select datename(year,getdate()) --2003