Date Formats
Date formats refer to the formatting of days, dates and times. You can use the following symbols to specify a date format.
|
Symbol |
Description |
|
/ |
Placeholder for date separator |
|
: |
Placeholder for time separator |
|
< |
Following characters will be converted to lowercase |
|
> |
Following characters will be converted to uppercase |
|
d |
Placeholder for day of month (1-31) |
|
dd |
Placeholder for day of month (01-31) |
|
ddd |
Placeholder for day of week (Sun-Sat). Depends on the language setting for the application (see IlvDisplay) |
|
dddd |
Placeholder for day of week (Sunday-Saturday). Depends on the language setting for the application (see IlvDisplay) |
|
ddddd |
Placeholder for full date (ex: 8/3/96). Depends on the global settings for the application (see IliFormat) |
|
dddddd |
Placeholder for full date (ex: 03 August 1996). Depends on the language setting (see IlvDisplay) and the global settings (see IliFormat) for the application |
|
w |
Placeholder for day of week (1-7) |
|
ww |
Placeholder for week of year (1-53) |
|
m |
Placeholder for month (1-12) |
|
mm |
Placeholder for month (01-12) |
|
mmm |
Placeholder for month (Jan-Dec). Depends on the language setting for the application (see IlvDisplay) |
|
mmmm |
Placeholder for month (January-December). Depends on the language setting for the application (see IlvDisplay) |
|
q |
Placeholder for quarter (1-4) |
|
y |
Placeholder for year day (1-366) |
|
yy |
Placeholder for year (00-99) |
|
yyyy |
Placeholder for year (1970-2099) |
|
h |
Placeholder for hour (0-23) |
|
hh |
Placeholder for hour (00-23) |
|
H |
Placeholder for hour (0-11) |
|
HH |
Placeholder for hour (00-11) |
|
p |
Placeholder for AM or PM |
|
n |
Placeholder for minutes (0-59) |
|
nn |
Placeholder for minutes (00-59) |
|
s |
Placeholder for seconds (0-59) |
|
ss |
Placeholder for seconds (00-59) |
|
ttttt |
Placeholder for full time (ex: 05:32:12). Depends on the global settings for the application (see IliFormat) |
Examples
|
Value |
Format |
Result |
|
12 jan 96 |
d/m/yy |
12/1/96 |
|
12 jan 96 |
d mmmm yyyy |
12 January 1996 |
|
12 jan 96 |
q |
1 |
The placeholders for the date and time separators are formatted according to application settings that may vary (typically, depending on the country).
Also, two of the format specifications depend on application settings that control wether the date should be displayed before or after the month. For example:
|
Value |
Format |
Application properties |
Result |
|
12 jan 96 |
dddddd |
MDY, English language |
January 12 1996 |
| 12 jan 96 | dddddd |
DMY, French language |
12 Janvier 1996 |
