Reference Manual
   CHAPTER 8. SQL Functions     

Date and time functions

Date and time functions perform operations on date and time data types or return date or time information.

List of functions 

The following date and time functions are available:

• DATE function

• DATEFORMAT function

• DATENAME function

• DATETIME function

• DAY function

• DAYNAME function

• DAYS function

• DOW function

• HOUR function

• HOURS function

• MINUTE function

• MINUTES function

• MONTH function

• MONTHNAME function

• MONTHS function

• NOW function

• QUARTER function

• SECOND

• SECONDS function

• TODAY function

• WEEKS function

• YEARS function

• YMD function

  Date parts

Many of the date functions use dates built from date parts. The following table displays allowed values of date-parts.

Date Part	Abbreviation	Values
Year	yyyy	1753 - 9999
Quarter	qq	1 - 4
Month	mm	1 - 12
Week	wk	1 - 54
Day	dd	1 - 31
Dayofyear	dy	1 - 366
Weekday	dw	1 - 7 (Sun.-Sat.)
Hour	hh	0 - 23
Minute	mi	0 - 59
Second	ss	0 - 59
Millisecond	ms	0 - 999
Calyearofweek	cyw	Integer. The year in which the week begins. The week containing the first few days of the year can be part of the last week of the previous year, depending on the weekday on which the year started. Years starting on Monday through Thursday have no days that are part of the previous year, but years starting on Friday through Sunday start their first week on the first Monday of the year.
Calweekofyear	cw	An integer from 1 to 54 representing the week number within the year that contains the specified date.
Caldayofweek	cdw	The day number within the week (Sunday = 1, Saturday = 7)