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