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) |
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 |
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 |