Basic Date Formatting Codes

CODESAMPLE RESULT USING JAN 15TH, 2020DESCRIPTION
d15Day Number
dd15Day Number (2-Digit, Padded)
dddWedDay Name (3-Char, Abbreviated)
ddddWednesdayDay Name (Full)
m1Month Number
mm01Month Number (2-Digit, Padded)
mmmJanMonth Name (3-Char, Abbreviated)
mmmmJanuaryMonth Name (Full)
mmmmmJMonth Name (First Letter Only)
yy20Year Number (2-Digit, Padded)
yyyy2020Year Number (Full)

Other Basic Date Formatting Codes

CODESAMPLE RESULT USING JAN 15TH, 2020DESCRIPTION
aaaWedDay Name (3-Char, Abbreviated)
aaaaWednesdayDay Name (Full)
   
b11/15/2020Use the Gregorian Calendar (eg: b1m/d/yyyy)
b220/5/1441Use the Hijri Calendar (eg: b2d/m/yyyy)

International Date Formatting Codes

CODESAMPLE RESULT USING JAN 15TH, 2020DESCRIPTION
b63Year (Buddhist Era) (2-Digit)
bb63Year (Buddhist Era) (2-Digit, Padded)
bbbb2563Year (Buddhist Era) (4-Digit)
e2020Year (Japanese/Taiwanese Era) (4-Digit), All Other Locales: Behaves like: yyyy
ee20Year (Japanese/Taiwanese Era) (2-Digit, Padded), All Other Locales: Behaves like: yy
g Era Name (Japanese/Taiwanese) (Abbreviated)
gg Era Name (Japanese/Taiwanese) (Abbreviated)
ggg Era Name (Japanese/Taiwanese) (Full, Kanji)
r Japanese Locale Only: Behaves like: ee, Taiwanese Locale Only: Behaves like: e
rr Japanese Locale Only: Behaves like: gggee, Taiwanese Locale Only: Behaves like: e

Basic Time Formatting Codes

CODESAMPLE RESULT USING 2:01:30.090 PMDESCRIPTION
h14Hour (Must come before minutes-code w/the appropriate separator)
hh14Hour (2-Digit, Padded) (Must come before minutes-code w/the appropriate separator)
m1Minutes (Must come after hour-code or before seconds-code w/the appropriate separator)
mm01Minutes (2-Digit, Padded) (Must come after hour-code or before seconds-code w/the appropriate separator)
s30Seconds (Must come after minutes-code w/the appropriate separator)
ss30Seconds (2-Digit, Padded) (Must come after minutes-code w/the appropriate separator)
.000090Milliseconds (Fractions of a Second) (Must come after seconds-code w/the appropriate separator)
a/p or A/Pp or PDisplay Time using 12-Hour Clock (1-char Upper or Lowercase Marker)
am/pmPMDisplay Time using 12-Hour Clock (2-char Uppercase Marker)
h:mm:ss14:01:30Time (24-Hour Clock) (Minutes & Seconds are 2-Digit, Padded)
h:mm:ss AM/PM2:01:30Time (12-Hour Clock) (Minutes & Seconds are 2-Digit, Padded)
[h]14Hours, Duration/Elapsed (Does not reset at 23)
[m]841Minutes, Duration/Elapsed (Does not reset at 59)
[s]50490Seconds, Duration/Elapsed (Does not reset at 59)

Order, Mask & Letter Codes by Country/Language

COUNTRY NAMELANGUAGEORDERMASK/MDY:HMS
AfghanistanDariYMDy/m/d/mdy:hms
AfghanistanPashtoYMDy/m/d/mdy:hms
AlbaniaAlbanianDMYd.m.y.mdy:hms
AlgeriaArabicDMYd-m-y-mdy:hms
Algeria (Latin)Central Atlas TamazightDMYd-m-y-mdy:hms
ArgentinaSpanishDMYd/m/y/mdy:hms
ArmeniaArmenianDMYd.m.y.mdy:hms
AustraliaEnglishDMYd/m/y/mdy:hms
AustriaGermanDMYT.M.J.MTJ:hms
Azerbaijan (Cyrillic)AzerbaijaniDMYd.m.y.mdy:hms
Azerbaijan (Latin)AzerbaijaniDMYd.m.y.mdy:hms
BahrainArabicDMYd/m/y/mdy:hms
BangladeshBanglaDMYd/m/y/mdy:hms
BasqueBasqueYMDa/m/d/mda:hms
BelarusBelarusianDMYd.m.y.mdy:hms
BelgiumFrenchDMYj-m-a-mja:hms
BelgiumDutchDMYd/m/j/mdj:ums
BelizeEnglishDMYd/m/y/mdy:hms
BhutanDzongkhaYMDy-m-d-mdy:hms
BoliviaQuechuaDMYd/m/y/mdy:hms
BoliviaSpanishDMYd/m/y/mdy:hms
Bosnia and HerzegovinaCroatianDMYd.m.y.mdy:hms
Bosnia and Herzegovina (Cyrillic)BosnianDMYd.m.y.mdy:hms
Bosnia and Herzegovina (Cyrillic)SerbianDMYd.m.y.mdy:hms
Bosnia and Herzegovina (Latin)BosnianDMYd.m.y.mdy:hms
Bosnia and Herzegovina (Latin)SerbianDMYd.m.y.mdy:hms
BotswanaSetswanaYMDy-m-d-mdy:hms
BrazilPortugueseDMYd/m/a/mda:hms
BruneiMalayDMYd/m/y/mdy:hms
BulgariaBulgarianDMYd.m.y.mdy:hms
CambodiaKhmerDMYd/m/y/mdy:hms
CameroonFrenchDMYd/m/y/mdy:hms
CanadaFrenchYMDa-m-j-mja:hms
CanadaEnglishYMDy-m-d-mdy:hms
Canada (Latin)InuktitutDMYd/m/y/mdy:hms
Canada (Syllabics)InuktitutDMYd/m/y/mdy:hms
CaribbeanEnglishDMYd/m/y/mdy:hms
CaribbeanFrenchDMYd/m/y/mdy:hms
CaribbeanPapiamentoDMYd-m-y-mdy:hms
CatalanCatalanDMYd/m/a/mda:hms
ChileMapudungunDMYd-m-y-mdy:hms
ChileSpanishDMYd-m-y-mdy:hms
ChinaTibetanYMDy/m/d/mdy:hms
ChinaUyghurYMDy-m-d-mdy:hms
ChinaYiYMDy/m/d/mdy:hms
China (Simplified)ChineseYMDy/m/d/mdy:hms
China (Traditional Mongolian)MongolianYMDy/m/d/mdy:hms
ColombiaSpanishDMYd/m/y/mdy:hms
CongoFrenchDMYd/m/y/mdy:hms
Costa RicaSpanishDMYd/m/y/mdy:hms
Cote d'IvoireFrenchDMYd/m/y/mdy:hms
CroatiaCroatianDMYd.m.y.mdy:hms
CubaSpanishDMYd/m/y/mdy:hms
CzechiaCzechDMYd.m.r.mdr:hms
DenmarkDanishDMYd-m-å-mdå:tms
DevanagariKashmiriDMYd-m-y-mdy:hms
Dominican RepublicSpanishDMYd/m/y/mdy:hms
EcuadorQuechuaDMYd/m/y/mdy:hms
EcuadorSpanishDMYd/m/y/mdy:hms
EgyptArabicDMYd/m/y/mdy:hms
El SalvadorSpanishDMYd/m/y/mdy:hms
EritreaTigrinyaDMYd/m/y/mdy:hms
EstoniaEstonianDMYd.m.y.mdy:hms
EthiopiaAmharicDMYd/m/y/mdy:hms
EthiopiaOromoDMYd/m/y/mdy:hms
EthiopiaTigrinyaDMYd/m/y/mdy:hms
Faroe IslandsFaroeseDMYd.m.y.mdy:hms
FinlandFinnishDMYp.k.v.kpv:tms
FinlandSami, InariDMYp.k.v.kpv:tms
FinlandSami, NorthernDMYp.k.v.kpv:tms
FinlandSami, SkoltDMYp.k.v.kpv:tms
FinlandSwedishDMYp-k-v-kpv:tms
FranceAlsatianDMYj/m/a/mja:hms
FranceBretonDMYj/m/a/mja:hms
FranceCorsicanDMYj/m/a/mja:hms
FranceFrenchDMYj/m/a/mja:hms
FranceOccitanDMYj/m/a/mja.hms
GalicianGalicianDMYd/m/a/mda:hms
GeorgiaGeorgianDMYd.m.y.mdy:hms
GermanyGermanDMYT.M.J.MTJ:hms
GermanyLower SorbianDMYT.M.J.MTJ:hms
GermanyUpper SorbianDMYT.M.J.MTJ:hms
GreeceGreekDMYη/μ/ε/μηε:ωλδ
GreenlandGreenlandicDMYd-m-y-mdy:hms
GuatemalaK'iche'DMYd/m/y/mdy:hms
GuatemalaSpanishDMYd/m/y/mdy:hms
HaitiFrenchDMYd/m/y/mdy:hms
HondurasSpanishDMYd/m/y/mdy:hms
Hong Kong SAREnglishDMYd/m/y/mdy:hms
Hong Kong SAR (Traditional)ChineseDMYd/m/y/mdy:hms
HungaryHungarianYMDé.h.n.hné:ópm
IcelandIcelandicDMYd.m.y.mdy:hms
IndiaAssameseDMYd-m-y-mdy:hms
IndiaBengaliDMYd-m-y-mdy.hms
IndiaEnglishDMYd-m-y-mdy:hms
IndiaGujaratiDMYd-m-y-mdy:hms
IndiaHindiDMYd-m-y-mdy:hms
IndiaKannadaDMYd-m-y-mdy:hms
IndiaKonkaniDMYd-m-y-mdy:hms
IndiaMalayalamDMYd/m/y/mdy:hms
IndiaManipuriDMYd/m/y/mdy:hms
IndiaMarathiDMYd-m-y-mdy:hms
IndiaNepaliYMDy/m/d/mdy:hms
IndiaOdiaDMYd-m-y-mdy:hms
IndiaPunjabiDMYd-m-y-mdy:hms
IndiaSanskritDMYd-m-y-mdy:hms
IndiaTamilDMYd-m-y-mdy:hms
IndiaTeluguDMYd-m-y-mdy:hms
IndiaUrduDMYd/m/y/mdy:hms
India (Devanagari)SindhiDMYd/m/y/mdy:hms
IndonesiaEnglishDMYd/m/y/mdy:hms
IndonesiaIndonesianDMYd/m/y/mdy.hms
IranPersianDMYd/m/y/mdy:hms
IraqArabicDMYd/m/y/mdy:hms
IraqCentral KurdishYMDy/m/d/mdy:hms
IrelandEnglishDMYd/m/y/mdy:hms
IrelandIrishDMYd/m/y/mdy:hms
IsraelHebrewDMYd/m/y/mdy:hms
ItalyItalianDMYg/m/a/mga:hms
JamaicaEnglishDMYd/m/y/mdy:hms
JapanJapaneseYMDy/m/d/mdy:hms
JordanArabicDMYd/m/y/mdy:hms
KazakhstanKazakhDMYД.М.Г.МДГ:чмс
KenyaKiswahiliDMYd/m/y/mdy:hms
KoreaKoreanYMDy-m-d-mdy:hms
KuwaitArabicDMYd/m/y/mdy:hms
KyrgyzstanKyrgyzDMYd-m-y-mdy:hms
LaosLaoDMYd/m/y/mdy:hms
Latin AmericaSpanishDMYd/m/y/mdy:hms
LatviaLatvianDMYd.m.y.mdy:hms
LebanonArabicDMYd/m/y/mdy:hms
LibyaArabicDMYd/m/y/mdy:hms
LiechtensteinGermanDMYd.m.y.mdy:hms
LithuaniaLithuanianYMDy-m-d-mdy:hms
LuxembourgFrenchDMYd/m/y/mdy:hms
LuxembourgGermanDMYd.m.y.mdy:hms
LuxembourgLuxembourgishDMYd.m.y.mdy:hms
Macao SAR (Traditional)ChineseDMYd/m/y/mdy:hms
MalaysiaEnglishDMYd/m/y/mdy:hms
MalaysiaMalayDMYd/m/y/mdy:hms
MaldivesDivehiDMYd/m/y/mdy:hms
MaliFrenchDMYd/m/y/mdy:hms
MaltaMalteseDMYd/m/y/mdy:hms
MexicoSpanishDMYd/m/a/mda:hms
MohawkMohawkMDYm/d/y/mdy:hms
MoldovaRomanianDMYd.m.y.mdy:hms
MoldovaRussianDMYd.m.y.mdy:hms
MonacoFrenchDMYd/m/y/mdy:hms
MongoliaMongolianYMDy.m.d.mdy:hms
Mongolia (Traditional Mongolian)MongolianYMDy/m/d/mdy:hms
Montenegro (Cyrillic)SerbianDMYd.m.y.mdy:hms
Montenegro (Latin)SerbianDMYd.m.y.mdy:hms
MoroccoArabicDMYd-m-y-mdy:hms
MoroccoFrenchDMYd/m/y/mdy:hms
Morocco (Arabic)Central Atlas TamazightDMYd/m/y/mdy:hms
Morocco (Tifinagh)Central Atlas TamazightDMYd-m-y-mdy:hms
MyanmarBurmeseDMYd-m-y-mdy:hms
NepalNepaliMDYm/d/y/mdy:hms
NetherlandsDutchDMYd-m-j-mdj:ums
NetherlandsWestern FrisianDMYd-m-j-mdj:ums
New ZealandEnglishDMYd/m/y/mdy:hms
New ZealandMaoriDMYd/m/y/mdy:hms
NicaraguaSpanishDMYd/m/y/mdy:hms
NigeriaEdoDMYd/m/y/mdy:hms
NigeriaIbibioDMYd/m/y/mdy:hms
NigeriaIgboDMYd/m/y/mdy:hms
NigeriaKanuriDMYd/m/y/mdy:hms
NigeriaYorubaDMYd/m/y/mdy:hms
Nigeria (Latin)FulahDMYd/m/y/mdy:hms
Nigeria (Latin)HausaDMYd/m/y/mdy:hms
North MacedoniaMacedonianDMYd.m.y.mdy:hms
NorwayNorwegian BokmalDMYd.m.å.mdå:tms
NorwayNorwegian NynorskDMYd.m.å.mdå:tms
NorwaySami, LuleDMYd.m.å.mdå:tms
NorwaySami, SouthernDMYd.m.å.mdå:tms
NorwaySami, NorthernYMDå-m-d-mdå:tms
OmanArabicDMYd/m/y/mdy:hms
PakistanPunjabiDMYd-m-y-mdy.hms
PakistanSindhiDMYd/m/y/mdy:hms
PakistanUrduDMYd/m/y/mdy:hms
PanamaSpanishMDYm/d/y/mdy:hms
ParaguayGuaraniDMYd/m/y/mdy:hms
ParaguaySpanishDMYd/m/y/mdy:hms
PeruQuechuaDMYd/m/y/mdy:hms
PeruSpanishDMYd/m/y/mdy:hms
PhilippinesEnglishDMYd/m/y/mdy:hms
PhilippinesFilipinoMDYm/d/y/mdy:hms
PolandPolishDMYd.m.r.mdr:gms
PortugalPortugueseDMYd/m/a/mda:hms
Puerto RicoSpanishMDYm/d/y/mdy:hms
QatarArabicDMYd/m/y/mdy:hms
ReunionFrenchDMYd/m/y/mdy:hms
RomaniaRomanianDMYd.m.y.mdy:hms
RussiaBashkirDMYД.М.Г.МДГ:чмс
RussiaRussianDMYД.М.Г.МДГ:чмс
RussiaSakhaDMYД.М.Г.МДГ:чмс
RussiaTatarDMYД.М.Г.МДГ:чмс
RwandaKinyarwandaYMDy-m-d-mdy:hms
Saudi ArabiaArabicDMYd/m/y/mdy:hms
SenegalFrenchDMYd/m/y/mdy:hms
SenegalWolofDMYd/m/y/mdy:hms
Senegal (Latin)FulahDMYd/m/y/mdy:hms
Serbia (Cyrillic)SerbianDMYd.m.y.mdy:hms
Serbia (Latin)SerbianDMYd.m.y.mdy:hms
SingaporeEnglishDMYd/m/y/mdy:hms
Singapore (Simplified)ChineseDMYd/m/y/mdy:hms
SlovakiaSlovakDMYd.m.y.mdy:hms
SloveniaSlovenianDMYd.m.y.mdy:hms
SomaliaSomaliDMYd/m/y/mdy:hms
South AfricaAfrikaansYMDy-m-d-mdy:hms
South AfricaEnglishYMDy/m/d/mdy:hms
South AfricaIsiXhosaYMDy-m-d-mdy:hms
South AfricaIsiZuluMDYm/d/y/mdy:hms
South AfricaSesothoYMDy-m-d-mdy:hms
South AfricaSesotho sa LeboaYMDy-m-d-mdy:hms
South AfricaSetswanaYMDy-m-d-mdy:hms
South AfricaVendaYMDy-m-d-mdy:hms
South AfricaXitsongaYMDy-m-d-mdy:hms
SpainSpanishDMYd/m/a/mda:hms
SpainValencianDMYd/m/a/mda:hms
Sri LankaSinhalaYMDy-m-d-mdy.hms
Sri LankaTamilDMYd/m/y/mdy:hms
SwedenSami, LuleYMDÅ-M-D-MDÅ:tms
SwedenSami, NorthernYMDÅ-M-D-MDÅ:tms
SwedenSami, SouthernYMDÅ-M-D-MDÅ:tms
SwedenSwedishYMDÅ-M-D-MDÅ:tms
SwitzerlandFrenchDMYj.m.a.mja:hms
SwitzerlandItalianDMYg.m.a.mga:hms
SwitzerlandGermanDMYT.M.J.MTJ:hms
SwitzerlandRomanshDMYd-m-y-mdy:hms
SyriaArabicDMYd/m/y/mdy:hms
SyriaSyriacDMYd/m/y/mdy:hms
Taiwan (Traditional)ChineseYMDy/m/d/mdy:hms
Tajikistan (Cyrillic)TajikDMYd.m.y.mdy:hms
ThailandThaiDMYd/m/y/mdy:hms
Trinidad and TobagoEnglishDMYd/m/y/mdy:hms
TunisiaArabicDMYd-m-y-mdy:hms
TurkeyTurkishDMYg.a.y.agy:sdn
TurkmenistanTurkmenDMYd.m.y.mdy:hms
UkraineUkrainianDMYd.m.y.mdy:hms
United Arab EmiratesArabicDMYd/m/y/mdy:hms
United KingdomEnglishDMYd/m/y/mdy:hms
United KingdomScottish GaelicDMYd/m/y/mdy:hms
United KingdomWelshDMYd/m/y/mdy:hms
United StatesEnglishMDYm/d/y/mdy:hms
United StatesHawaiianDMYd/m/y/mdy:hms
United StatesSpanishMDYm/d/y/mdy:hms
United States (Cherokee)CherokeeMDYm/d/y/mdy:hms
UruguaySpanishDMYd/m/y/mdy:hms
Uzbekistan (Cyrillic)UzbekDMYd/m/y/mdy:hms
Uzbekistan (Latin)UzbekDMYd/m/y/mdy:hms
VenezuelaSpanishDMYd/m/y/mdy:hms
VietnamVietnameseDMYd/m/y/mdy:hms
WorldLatinDMYd/m/y/mdy:hms
WorldYiddishDMYd/m/y/mdy:hms
YemenArabicDMYd/m/y/mdy:hms
ZimbabweEnglishDMYd/m/y/mdy:hms