Data Access Getting Started > Format Syntax > Date Formats
 
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

Version 6.0
Copyright © 2015, Rogue Wave Software, Inc. All Rights Reserved.