Date/Time format rules
This page includes details about Date format options, available in Date, Time and DateTime columns.
You can use any of available types to specify a format of date displayed in Date, Time and DateTime column type.
Default date format is L. Default time format is hh:mm A
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 |