page
Home
About Us
Contact Us
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
Facebook
Twitter
Google+
Pinterest
StumbleUpon
Dig
LinkedIn
No comments :
Post a Comment
Newer Post
Older Post
Home
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
No comments :
Post a Comment