| Excerpt | ||
|---|---|---|
| ||
You can use any of the available types to specify a format of the date displayed in Date, Time and DateTime column type. |
This page includes details about Date format options, available in Date, Time and DateTime columns.
You can use any of the available types to specify a format of the date displayed in Date, Time and DateTime column type.
| Tip |
|---|
...
Default date format is L. Default time format is hh:mm A |
There are some predefined format presets 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 |
| Anchor | ||||
|---|---|---|---|---|
|
Format preset | Example (en locale) | Example (de locale) |
|---|---|---|
LT | 8:30 PM | 20:30 |
LTS | 8:30:25 PM | 20:30:25 |
L | 08/ |
...
21/1985 |
...
21.08.1985 | |
l | 8/ |
...
21/1985 |
...
21.8.1985 | |
LL | August |
...
21 1985 |
...
21. August 1985 | |
ll | Aug |
...
21 1985 |
...
2. Aug. 1985
...
LLL
...
August 2
1985
08:30 PM
...
2. August 1985 20:30
...
Aug 2 1985 08:30 PM
...
2. Aug. 1985 20:30
...
LLLL
...
Thursday, August 2
1985
08:30 PM
...
Donnerstag, 2. August 1985 20:30
...
Thu, Aug 2
1985
08:30 PM
...
21. Aug. 1985 |