etdate-part-and-extract-fields.md
CENTURY- The century number.
The first century starts at 0001-01-01 00:00:00 AD. This definition applies to all Gregorian calendar countries. There is no century number 0, you go from –1 to 1.
DAY- The day (of the month) field (1–31).
DECADE- The year field divided by 10.
DOQ- The day within the current quarter. DOQ recognizes leap year days.
DOW- Zero-based day of the week, where Sunday=0.
DOY- The day of the year (1–365/366)
EPOCH- Specifies to return one of the following:
-
For
DATEandTIMESTAMPvalues: the number of seconds before or since 1970-01-01 00:00:00-00 (if before, a negative number). -
For
INTERVALvalues, the total number of seconds in the interval.
-
HOUR- The hour field (0–23).
ISODOW- The ISO day of the week, an integer between 1 and 7 where Monday is 1.
ISOWEEK- The ISO week of the year, an integer between 1 and 53.
ISOYEAR- The ISO year.
MICROSECONDS- The seconds field, including fractional parts, multiplied by 1,000,000. This includes full seconds.
MILLENNIUM- The millennium number, where the first millennium is 1 and each millenium starts on
01-01-y001. For example, millennium 2 starts on 01-01-1001. MILLISECONDS- The seconds field, including fractional parts, multiplied by 1000. This includes full seconds.
MINUTE- The minutes field (0 - 59).
MONTH- For
TIMESTAMPvalues, the number of the month within the year (1 - 12) ; forintervalvalues the number of months, modulo 12 (0 - 11). QUARTER- The calendar quarter of the specified date as an integer, where the January-March quarter is 1, valid only for
TIMESTAMPvalues. SECOND- The seconds field, including fractional parts, 0–59, or 0-60 if the operating system implements leap seconds.
TIME ZONE- The time zone offset from UTC, in seconds. Positive values correspond to time zones east of UTC, negative values to zones west of UTC.
TIMEZONE_HOUR- The hour component of the time zone offset.
TIMEZONE_MINUTE- The minute component of the time zone offset.
WEEK- The number of the week of the calendar year that the day is in.
YEAR- The year field. There is no
0 AD, so subtractBCyears fromADyears accordingly.