1.6

Table Of Contents
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 In addition, any constant character can be included in the mask, usually to indicate
date/time separators (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 "Date and time patterns" on page764).
Examples of masks
Value in raw data Mask to use
June 25, 2013 MM dd, YYYY
06/25/13 mm/dd/yy
2013.06.25 yyyy.mm.dd
2013-06-25 07:31 PM yyyy-mm-dd hh:nn ap
2013-06-25 19:31:14.1206 yyyy-mm-dd hh:nn:ss.ms
Tuesday, June 25, 2013 @ 7h31PM DD, MM dd, yyyy @ hh\hnnap
Page 146