DATEDIFF function in SQL Server
Developer
By the Developer, For the Developer.
Sunday, 4 December 2011
DATEDIFF function in SQL Server
Synatx
DATEDIFF ( datepart , startdate , enddate )
Argument
Datepart-
Abbreviations
year-
yy, yyyy
quarter-
qq, q
month-
mm, m
dayofyear-
dy, y
day-
dd, d
week-
wk, ww
Hour
-
hh
minute-
mi, n
second-
ss, s
millisecond-
ms
Return type
integer
No comments:
Post a comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a comment