SQL - DatePart

SQL - DatePart İşlemleri

sql - datepart , datepart(yyyy,TARIH)
yyyy: Year
q: Quarter
m: Month
y: Day of year
dy: Day of year
d: Day
w: Weekday
ww: Week
h: Hour
n: Minute
s: Second
l: Millisecond

datepart(yy,TARIH)=datepart(yy,getdate()) --bu yıl
datepart(mm,TARIH)=datepart(mm,getdate()) --bu ay
datepart(mm,TARIH)=datepart(mm,getdate()) and datepart(yy,TARIH)=datepart(yy,getdate()) --bu yil,bu ay
datepart(wk,TARIH)=datepart(wk,getdate()) --bu hafta
datepart(wk,TARIH)=datepart(wk,getdate()) and datepart(yy,TARIH)=datepart(yy,getdate()) --bu yıl,bu hafta
datepart(dy,TARIH)=datepart(dy,getdate()) --bugun
datepart(dy,TARIH)=datepart(dy,getdate()) and datepart(yy,TARIH)=datepart(yy,getdate()) --bu yıl,bugun
floor(cast(TARIH as float))=floor(cast(getdate() as float)) -- bugun