Data Access User Manual > Rogue Wave Views Data Access Gadgets > Format Syntax > Date Formats
 
Date Formats
Date formats refer to the formatting of days, dates, and times.
Symbols
You can use the following symbols to specify a date format:
/
Placeholder for date separator.
:
Placeholder for time separator.
<
Characters following the symbol will be converted to lowercase.
>
Characters following the symbol 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 that has been set for the application.
See the IlvDisplay class.
dddd
Placeholder for day of week (Sunday-Saturday). Depends on the language that has been set for the application.
See the IlvDisplay class.
ddddd
Placeholder for full date (ex: 8/3/96. Depends on the global settings of your application.
See the IliFormat class.
dddddd
Placeholder for full date (ex: 03 August 1996).
Depends on the language and the global settings
that have been set for the application.
See the IlvDisplay and IliFormat classes.
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 that has been set
for the application. See the IlvDisplay class.
mmmm
Placeholder for month (January-December).
Depends on the language that has been
set for the application. See the IlvDisplay class.
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 of your application.
See the IliFormat class.
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 can vary (typically, depending on the country).
Also, two of the format specifications depend on application settings that control if 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

Version 5.8
Copyright © 2014, Rogue Wave Software, Inc. All Rights Reserved.