Wednesday, May 14, 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,q 

month| mm,m 

dayofyear| dy,y 

day| dd,d 

week| wk,ww 

weekday| dw, w 

hour| hh

minute| mi,n 

second| ss, s

By at
Tags

No comments :

Post a Comment

Subscribe to: Post Comments ( Atom )
AJAX, asp, Asp.net, asp.net and sql server security, Asp.net IntemIndex, C#, Css, DataBinder.Eval, DataKeyNames, Datalist, Datapager, DataSet, DataTable, DropDownList, FindControl, gridview, JavaScript, jquery, Listview, Paging, Regex, RegularExpression, Repeater, Server side validation, Sql Server, timer, timercallback, Validation, XML, xmlnode, XPath