Formatting reference

These tables display the date and number formatting directives within the XML tags.

Number format for Layout tag

Symbol Location Localized? Description
0 Number Yes Digit
# Number Yes Digit, zero shows as absent.
. Number Yes Decimal separator or monetary decimal separator.
- Number Yes Minus sign.
, Number Yes Grouping separator.
E Number Yes Separates mantissa and exponent in scientific notation. Does not need to be quoted in prefix or suffix.
; Sub-pattern boundary Yes Separates positive and negative sub-patterns.
% Prefix or suffix Yes Multiply by 100 and show as percentage.
\u2030 Prefix or suffix Yes Multiply by 1000 and show as per mille.
ยค (\u00A4) Prefix or suffix No Currency sign, replaced by currency symbol. If doubled, replaced by international currency symbol. If present in a pattern, the monetary decimal separator is used instead of the decimal separator.
' Prefix or suffix No Used to quote special characters in a prefix or suffix, for example, "'#'#" formats 123 to "#123". To create a single quote, use two in a row: "# o''clock".

Datatime format for Layout tag

Letter Date or Time Component Presentation Examples
G Era designator Text AD
y Year Year 1996, 96
M Month in year Month July, Jul, 07
w Week in year Number 27
W Week in month Number 2
D Day in year Number 189
d Day in month Number 10
F Day of week in month Number 2
E Day in week Text Tuesday, Tue
a Am/pm marker Text PM
H Hour in day (0-23) Number 0
k Hour in day (1-24) Number 24
K Hour in am/pm (0-11) Number 0
h Hour in am/pm (1-12) Number 12
m Minute in hour Number 30
s Second in minute Number 55
S Millisecond Number 978
z Time zone General time zone Pacific Standard Time, PST, GMT-08:00
Z Time zone RFC 822 time zone -0800
DAYS_SINCE_1900_01_01 Days since 1900 Number 37752