1 |
A. Standard characters. |
2 |
AHEX. Hexadecimal
characters. |
3 |
COMMA. Numbers with
commas as the grouping symbol and a period as the decimal indicator.
For example: 1,234,567.89. |
4 |
DOLLAR. Numbers with
a leading dollar sign ($), commas as the grouping symbol, and a period
as the decimal indicator. For example: $1,234,567.89. |
5 |
F. Standard numeric. |
6 |
IB. Integer binary. |
7 |
PIBHEX. Hexadecimal
of PIB (positive integer binary). |
8 |
P. Packed decimal. |
9 |
PIB. Positive integer
binary. |
10 |
PK. Unsigned packed
decimal. |
11 |
RB. Real binary. |
12 |
RBHEX. Hexadecimal
of RB (real binary). |
15 |
Z. Zoned decimal. |
16 |
N. Restricted numeric. |
17 |
E. Scientific notation. |
20 |
DATE. International
date of the general form dd-mmm-yyyy. |
21 |
TIME. Time of the general
form hh:mm:ss.ss. |
22 |
DATETIME. Date and
time of the general form dd-mmm-yyyy hh:mm:ss.ss. |
23 |
ADATE. American date
of the general form mm/dd/yyyy. |
24 |
JDATE. Julian date
of the general form yyyyddd. |
25 |
DTIME. Days and time
of the general form dd hh:mm:ss.ss. |
26 |
WKDAY. Day of the week. |
27 |
MONTH. Month. |
28 |
MOYR. Month and year. |
29 |
QYR. Quarter and year
of the general form qQyyyy. |
30 |
WKYR. Week and year. |
31 |
PCT. Percentage sign
after numbers. |
32 |
DOT. Numbers with
periods as the grouping symbol and a comma as the decimal indicator.
For example: 1.234.567,89. |
33 |
CCA. Custom currency
format 1. |
34 |
CCB. Custom currency
format 2. |
35 |
CCC. Custom currency
format 3. |
36 |
CCD. Custom currency
format 4. |
37 |
CCE. Custom currency
format 5. |
38 |
EDATE. European date
of the general form dd.mm.yyyy. |
39 |
SDATE. Sortable date
of the general form yyyy/mm/dd. |
85 |
MTIME. Time of the general form mm:ss.ss. |
86 |
YMDHMS. Date and time of the general form yyyy-mm-dd hh:mm:ss.ss. |