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 |