Date Formats Customization

Date Formatting Tokens

CharacterDescriptionExample
dDay of the month, 2 digits with leading zeros01 to 31
DA textual representation of a dayMon through Sun
l (lowercase ‘L’)A full textual representation of the day of the weekSunday through Saturday
jDay of the month without leading zeros1 to 31
JDay of the month without leading zeros and ordinal suffix1st, 2nd, to 31st
wNumeric representation of the day of the week0 (for Sunday) through 6 (for Saturday)
WNumeric representation of the week0 (first week of the year) through 52 (last week of the year)
FA full textual representation of a monthJanuary through December
mNumeric representation of a month, with leading zero01 through 12
nNumeric representation of a month, without leading zeros1 through 12
MA short textual representation of a monthJan through Dec
UThe number of seconds since the Unix Epoch1413704993
yA two digit representation of a year99 or 03
YA full numeric representation of a year, 4 digits1999 or 2003
ZISO Date format2017-03-04T01:23:43.000Z

Time Formatting Tokens

CharacterDescriptionExample
HHours (24 hours)00 to 23
hHours1 to 12
GHours, 2 digits with leading zeros1 to 12
iMinutes00 to 59
SSeconds, 2 digits00 to 59
sSeconds0, 1 to 59
KAM/PMAM or PM

Was this article helpful to you?

How can we help?

Please submit a support ticket if you have any question or pre-sale questions. Our Customer support engineers will answer your query as soon as possible

Open a support ticket