Wednesday, 14 May 2008

Using Dateadd function adding day,month,year in date


select


dateadd(datepart,number,date)

eg-



select


DATEADD(month, 3, getdate()) 



Datepart


|Abbreviations

year| yy,yyyy 

quarter| qq,

month| mm,

dayofyear| dy,

day| dd,

week| wk,ww 

weekday| dw,

hour| hh

minute| mi,

second| ss, s

Share:

0 Comments:

Post a Comment