Date and time formats for importing watchlist CSV files
When you import a watchlist into Sintelix, if one of the columns in the CSV file A 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. : Pattern letters in datetime formats shows the pattern letters. : Examples of date and time patterns shows examples of date and time patterns.
Pattern letters
|
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.
|
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 |