DateFormat

Specifies the date format that the connector expects to receive and return. This property supports any format that is based on the syntax as contained in Table 1.

Table 1 defines the DateFormat syntax using a time pattern string. In this pattern, all ASCII letters are reserved as pattern letters.

Table 1. DateFormat syntax

Symbol Meaning Presentation Example
G
era designator
(Text)
AD
y
year
(Number)
1996
M
month in year
(Text & Number)
July & 07
d
day in month
(Number)
10
h
hour in am/pm(1-12)
(Number)
12
H
hour in day(0-23)
(Number)
0
m
minute in hour
(Number)
30
s
second in minute
(Number)
55
S
millisecond
(Number)
978
E
day in week
(Text)
Tuesday
D
day in year
(Number)
189
F
day of week in month
(Number)
2
(2nd Wed
in July)
w
week in year
(Number)
27
W
week in month
(Number)
2
a
am/pm marker
(Text)
PM
k
hour in day(1-24)
(Number)
24
K
hour in am/pm(0-11)
(Number)
0
z
time zone
(Text)
Pacific
Standard
Time
escape for text (Delimiter)

''
single quote (Literal)
'


Table 2. Examples using the US locale

Format pattern Result
"yyyy.MM.dd G 'at' hh:mm:ss z"
1996.07.10 AD at 15:08:56 PDT
"EEE, MMM d, ''yy"
Wed, July 10, '96
"h:mm a"
12:08 PM
"hh 'o''clock' a, zzzz"
12 o'clock PM, Pacific Daylight Time
"K:mm a, z"
0:00 PM, PST
"yyyy.MMMMM.dd GGG hh:mm aaa"
1996.July.10 AD 12:08 PM

Default value: MM/dd/yyyy, HH/mm/ss

Possible values: A time pattern String

Required: No

Copyright IBM Corp. 1997, 2004