2022.2

DateTimeobject.HowtheyaredisplayedintheDataModeldependsonthepreferences(see
"DefaultFormat"onpage786)..
Defining a date/time format
Adateformatisamaskrepresentingtheorderandmeaningofeachdigitintherawdata,aswellasthe
date/timeseparators.Themaskusesseveralpredefinedmarkerstoparsethecontentsoftherawdata.
HereisalistofmarkersthatareavailableintheDataMapper:
l
yy:NumericrepresentationoftheYearwhenitiswrittenoutwithonly2digits(i.e.13)
l
yyyy:NumericrepresentationoftheYearwhenitiswrittenoutwith4digits(i.e.2013)
l
M:Shortversionofthemonthname(i.e.Jan,Aug).Thesevaluesarebasedonthecurrent
regionalsettings.
l
MM:Longversionofthemonthname(i.e.January,August).Thesevaluesarebasedonthecur-
rentregionalsettings.
l
mm:Numericrepresentationofthemonth(i.e.1,09,12)
l
D:Shortversionoftheweekdayname(i.e.Mon,Wed).Thesevaluesarebasedonthecurrent
regionalsettings.
l
DD:Longversionoftheweekdayname(i.e.Monday,Wednesday).Thesevaluesarebasedon
thecurrentregionalsettings.
l
dd:Numericrepresentationofthedayofthemonth(i.e.1,09,22)
l
hh:Numericrepresentationofthehours
l
nn:Numericrepresentationoftheminutes
l
ss:Numericrepresentationoftheseconds
l
ms:Numericrepresentationofthemilliseconds.
l
ap:AM/PMstring.
l
x:Indicatesatimezoneintheformof+05
l
xx:Indicatesatimezoneintheformof+0500
l
xxx:Indicatesatimezoneintheformof+05:00
l
Inaddition,anyconstantcharactercanbeincludedinthemask,usuallytoindicatedate/timesep-
arators(i.e./ - :).Ifoneofthosecharactershappenstobeoneofthereservedcharacterslisted
above,itmustbeescapedusingthe\symbol.
Note: Themarkersthatcanbeusedwhenextractingdatesaredifferentfromthosethatare
usedtodisplaydatesinatemplate(seetheDesigner's"Dateandtimepatterns"onpage1180).
Page 279