When you create a data import job, you must specify a format for the time field. The following sections list the supported time format syntax and examples.
Time format syntax
|
Character |
Description |
Example |
|
G |
Era designator |
AD |
|
y |
Year |
2001 |
|
M |
Month |
July 7 |
|
d |
Date |
10 |
|
h |
Hour in AM or PM (1 to 12) |
12 |
|
H |
Hour in day (0 to 23) |
22 |
|
m |
Minute |
30 |
|
s |
Second |
55 |
|
S |
Millisecond |
234 |
|
E |
Week |
Tuesday |
|
D |
Day in year |
360 |
|
F |
Day of week in month |
2 |
|
w |
Week in year |
40 |
|
W |
Week in month |
1 |
|
a |
AM or PM |
PM |
|
k |
Hour in day (1 to 24) |
24 |
|
K |
Hour in AM or PM (0 to 11) |
10 |
|
z |
Time zone |
Eastern Standard Time |
|
' |
Delimiter |
Delimiter |
|
" |
Double quotation mark |
" |
Time format examples
-
XX: the ISO 8601 time zone. Example:+0800. -
XXX: the ISO 8601 time zone. Example:+08:00. -
zzz: the abbreviation of a time zone. Example:CST.
|
Date format |
Parsing syntax |
Parsed value (unit: seconds) |
|
2020-05-02 17:30:30 |
yyyy-MM-dd HH:mm:ss |
1588411830 |
|
2020-05-02 17:30:30:123 |
yyyy-MM-dd HH:mm:ss:SSS |
1588411830 |
|
2020-05-02 17:30 |
yyyy-MM-dd HH:mm |
1588411800 |
|
2020-05-02 17 |
yyyy-MM-dd HH |
1588410000 |
|
20-05-02 17:30:30 |
yy-MM-dd HH:mm:ss |
1588411830 |
|
2020-05-02T17:30:30Z |
yyyy-MM-dd'T'HH:mm:ss'Z' |
1588411830 |
|
2020-05-02T17:30:30.387Z |
yyyy-MM-dd'T'HH:mm:ss.SSS'Z' |
1588411830 |
|
02/May/2020:17:30:30 +0800 |
dd/MMM/yyyy:HH:mm:ss XX |
1588411830 |
|
02/May/2020:17:30:30 +08:00 |
dd/MMM/yyyy:HH:mm:ss XXX |
1588411830 |
|
2/May/2020:17:30:30 +0800 |
d/MMM/yyyy:HH:mm:ss XX |
1588411830 |
|
Sat May 02 17:30:30 CST 2020 |
EEE MMM dd HH:mm:ss zzz yyyy |
1588411830 |