Date and time formats for importing watchlist CSV files

When you import a watchlist into ETA, if one of the columns in the CSV fileA Comma Separated Variable file, where variables in the file are separated by a comma, a tab, a semicolon or another character. contains dates and/or times you can specify the pattern in which they are formatted so that they are displayed correctly is node fields. Table 1 shows the pattern letters. Table 2 shows examples of date and time patterns.

Pattern letters

Table 1: Pattern letters in datetime formats

Letter

Date or time component

Presentation

Examples

G

Era designator

Text

AD

y

Year

Year

1996; 96

Y

Week year

Year

2009; 09

M

Month in year

Month

July; Jul; 07

w

Week in year

Number

27

W

Week in month

Number

2

D

Day in year

Number

189

d

Day in month

Number

10

F

Day of week in month

Number

2

E

Day name in week

Text

Tuesday; Tue

u

Day number of week (1 = Monday, ..., 7 = Sunday

Number

1

a

Am/pm marker

Text

PM

H

Hour in day (0–23)

Number

0

k

Hour in day (1–24)

Number

24

K

Hour in am/pm (0–11)

Number

0

h

Hour in am/pm (1–12)

Number

12

m

Minute in hour

Number

30

s

Second in minute

Number

55

S

Millisecond

Number

978

z

Time zone

General time zone

Pacific Standard Time; PST; GMT-08:00

Z

Time zone

RFC 822 time zone

-0800

X

Time zone

ISO 8601 time zone

-08; -0800; -08:00

Examples of date and time patterns

The examples below show how date and time patterns are interpreted in the US locale. The given time and date are 2017-07-04 12:08 local time in the US Pacific Time time zone.

Table 2: Examples of date and time patterns

Date and time pattern

Result

"yyyy.MM.dd G 'at' HH:mm:ss z"

2017.07.04 AD at 12:08:56 PDT

"EEE, MMM d, ''yy"

Wed, Jul 4, '17

"h:mm a"

12:08 PM

"hh 'o''clock' a, zzzz"

12 o'clock PM, Pacific Daylight Time

"K:mm a, z"

0:08 PM, PDT

"yyyyy.MMMMM.dd GGG hh:mm aaa"

02017.July.04 AD 12:08 PM

"EEE, d MMM yyyy HH:mm:ss Z"

Wed, 4 Jul 2017 12:08:56 -0700

"yyMMddHHmmssZ"

170704120856-0700

"yyyy-MM-dd'T'HH:mm:ss.SSSZ"

2017-07-04T12:08:56.235-0700

"yyyy-MM-dd'T'HH:mm:ss.SSSXXX"

2017-07-04T12:08:56.235-07:00

"YYYY-'W'ww-u"

2017-W27-3

 

fontfontfont