Page History: DateAdd, DateDiff, and DatePart Functions - SQL Server

Compare Page Revisions

3 2 1 0 Current 3 2 1 0

« Older Revision - Back to Page History - Current Revision

Page Revision: Thu, Jan 07, 2010, 9:02 AM

Syntax¶

Function	Syntax	Notes
DateAdd	DATEADD(datepart, number, date)
DateDiff	DATEDIFF(datepart, startdate, enddate)
DatePart	DATEPART(datepart, date)

DatePart Argument¶

Datepart	Abbreviation	Functions
day	dd, d	All functions
dayofyear	dy, y	All functions
hour	hh	All functions
ISO_WEEK	isowk, isoww	New to SQL Server 2008 DatePart function
microsecond	mcs	New to all SQL Server 2008 functions
millisecond	ms	All functions
minute	mi, n	All functions
month	mm, m	All functions
nanosecond	ns	New to all SQL Server 2008 functions
quarter	qq, q	All functions
second	ss, s	All functions
TZoffset	tz	New to SQL Server 2008 DatePart function
week	wk, ww	All functions
weekday	dw, w	DateAdd and Date Part
year	yy, yyyy	All functions