Using Dateadd function adding day,month,year in date Written by Suresh Sharma on May 14, 2008 in Sql Server with No comments select dateadd(datepart,number,date)eg-select DATEADD(month, 3, getdate()) Datepart|Abbreviationsyear| yy,yyyy quarter| qq,q month| mm,m dayofyear| dy,y day| dd,d week| wk,ww weekday| dw, w hour| hhminute| mi,n second| ss, s Share: Email ThisBlogThis!Share to XShare to Facebook
0 Comments:
Post a Comment