Syntax
DATEADD (datepart , number, date )
Arguments
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
millisecond- ms
Retun Type
Returns datetime, but smalldatetime if the date argument is smalldatetime.
DATEADD (datepart , number, date )
Arguments
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
millisecond- ms
Retun Type
Returns datetime, but smalldatetime if the date argument is smalldatetime.
No comments:
Post a Comment