This page includes details about Date format options, available in Date and DateTime columns.
You can use any of available types to specify a format of date displayed in Date and DateTime column type.
By default used format L
There are some predefined format presents based on locale available.
Date format specifications
| Category | Format | Example |
|---|---|---|
| Weekday | d | 0..6 |
| dd | Su | |
| ddd | Sun | |
| dddd | Sunday | |
| Year | YY | 17 |
| YYYY | 2017 | |
| Month | M | 1..12 |
| Mo | 1st..12th | |
| MM | 01..12 | |
| MMM | Jan | |
| MMMM | January | |
| Quarter | Q | 1..4 |
| Qo | 1st..4th | |
| Day | D | 1..31 |
| Do | 1st..31st | |
| DD | 01..31 | |
| Day of year | DDD | 1..365 |
| DDDo | 1st..365th | |
| DDDD | 001..365 | |
| Week of year | w | 1..53 |
| wo | 1st..53rd | |
| ww | 01..53 |
Time format specifications
| Category | Format | Example |
|---|---|---|
| AM/PM | A | AM PM |
| a | am pm | |
| Hour | H | 0 1 ... 22 23 |
| HH | 00 01 ... 22 23 | |
| h | 1 2 ... 11 12 | |
| hh | 01 02 ... 11 12 | |
| k | 1 2 ... 23 24 | |
| kk | 01 02 ... 23 24 | |
| Minute | m | 0 1 ... 58 59 |
| mm | 00 01 ... 58 59 | |
| Second | s | 0 1 ... 58 59 |
| ss | 00 01 ... 58 59 |
Predefined date and time presets based on locale
Format preset | Example (en locale) | Example (de locale) |
|---|---|---|
LT | 8:30 PM | 20:30 |
LTS | 8:30:25 PM | 20:30:25 |
L | 08/02/1985 | 02.08.1985 |
l | 8/02/1985 | 02.8.1985 |
LL | August 2 1985 | 2. August 1985 |
ll | Aug 2 1985 | 2. Aug. 1985 |