SQL
Part Specifiers Usable as Date Part Specifiers and in Intervals
| Specifier | Description | Synonyms | Example |
|:--|:--|:---|:-|
| `'century'` | Gregorian century | `'cent'`, `'centuries'`, `'c'` | `21` |
| `'day'` | Gregorian day | `'days'`, `'d'`, `'dayofmonth'` | `3` |
| `'decade'` | Gregorian decade | `'dec'`, `'decades'`, `'decs'` | `202` |
| `'hour'` | Hours | `'hr'`, `'hours'`, `'hrs'`, `'h'` | `11` |
| `'microseconds'` | Sub-minute microseconds | `'microsecond'`, `'us'`, `'usec'`, `'usecs'`, `'usecond'`, `'useconds'` | `44123456` |
| `'millennium'` | Gregorian millennium | `'mil'`, `'millenniums'`, `'millenia'`, `'mils'`, `'millenium'` | `3` |
| `'milliseconds'` | Sub-minute milliseconds | `'millisecond'`, `'ms'`, `'msec'`, `'msecs'`, `'msecond'`, `'mseconds'` | `44123` |
| `'minute'` | Minutes | `'min'`, `'minutes'`, `'mins'`, `'m'` | `59` |
| `'month'` | Gregorian month | `'mon'`, `'months'`, `'mons'` | `8` |
| `'quarter'` | Quarter of the year (1-4) | `'quarters'` | `3` |
| `'second'` | Seconds | `'sec'`, `'seconds'`, `'secs'`, `'s'` | `44` |
| `'year'` | Gregorian year | `'yr'`, `'y'`, `'years'`, `'yrs'` | `2021` |