MILLENNIUM | A thousand years |
CENTURY | A hundred years; a number between 1 and 10 |
DECADE | Ten years; a number between 1 and 10 |
YEAR | One year; can be positive or negative |
QUARTER | 1/4 of a year; a number between 1 and 4 |
MONTH | One month; a number between 1 and 12 |
WEEK | Seven days. The definition of "week" is quite involved: The year's first week is the week containing the first Thursday of the year or either the week containing the 4th of January or either the week that begins between 29th of Dec. and 4th of Jan. The week number is thus a value between 0 and 53. |
DOY | Day of year, a number between 1 and 366 |
DOW | Day of week, with Sunday being 1 and Saturday being 7 |
ISODOW | ISO day of the week, with Monday 1 and Sunday 7 |
DAY | A day within a month, a number between 1 and 31 |
HOUR | An hour within a day, a number between 0 and 23 |
MINUTE | A minute within an hour, a number between 0 and 59 |
SECOND | A second within a minute, a number between 0 and 59 |
MILLISECOND | A millisecond within a minute, including the number of seconds multiplied by 1000, a number between 0 and 59,999 |
MICROSECOND | A microsecond within a minute, including the number of seconds multiplied by 1,000,000, a number between 0 and 59,999,999 |
EPOCH | Number of seconds from Unix epoch, i.e., 1970/01/01. |
SQL_TSI_YEAR | Same as YEAR |
SQL_TSI_QUARTER | Same as QUARTER |
SQL_TSI_MONTH | Same as MONTH |
SQL_TSI_WEEK | Same as WEEK |
SQL_TSI_HOUR | Same as HOUR |
SQL_TSI_DAY | Same as DAY |
SQL_TSI_MINUTE | Same as MINUTE |
SQL_TSI_SECOND | Same as SECOND |