Generic Import Time/Date patterns
- Daniel Balog
This article describes the valid time/date patterns in the Generic Import Source.
The time pattern must follow the required format of %[primitive][separator]
Examples
| Source string | Time pattern |
|---|---|
| 1999-12-31 23:12:01.118 | %yyyy-%MM-%dd %HH:%mm:%ss.%fff |
| december 31 99 | %MMMM %dd %yy |
| january 21 05 Saturday | %MMMM %dd %yy %dddd |
| 11:12:31 PM | %hh:%mm:%ss %tt |
| 1548236960 | %epochS |
Primitives
| Primitive | Description | Examples |
|---|---|---|
dddd | The full name of the day of the week | Sunday,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday |
ddd | The abbreviated name of the day of the week | Sun,Mon,Tue,Wed,Thu,Fri,Sat |
dd | The day of the month. Single-digit days will have a leading zero |
|
d | The day of the month. Single-digit days will not have a leading zero |
|
MMMM | The full name of the month | January,February,March,April,May,June,July,August,September,October,November,December |
MMM | The abbreviated name of the month | Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec |
MM | The numeric month. Single-digit months will have a leading zero |
|
M | The numeric month. Single-digit months will not have a leading zero |
|
yyyy | The year in four digits, including the century |
|
yy | The year without the century. The year is displayed with a leading zero |
|
y | The year without the century. The year is displayed without a leading zero |
|
hh | The hour in a 12-hour clock. Single-digit hours will have a leading zero |
|
h | The hour in a 12-hour clock. Single-digit hours will not have a leading zero |
|
HH | The hour in a 24-hour clock. Single-digit hours will have a leading zero |
|
H | The hour in a 24-hour clock. Single-digit hours will not have a leading zero |
|
mm | The minute. Single-digit minutes will have a leading zero |
|
m | The minute. Single-digit minutes will not have a leading zero |
|
ss | The second. Single-digit seconds will have a leading zero |
|
s | The second. Single-digit seconds will not have a leading zero |
|
fff | The fraction of a second in three-digit precision. The remaining digits are truncated. |
|
ff | The fraction of a second in double-digit precision. The remaining digits are truncated. |
|
f | The fraction of a second in single-digit precision. The remaining digits are truncated |
|
tt | The AM/PM designator |
|
t | The first character in the AM/PM designator |
|
zzz | The full time zone offset ("+" or "-" followed by the hour and minutes). Single-digit hours and minutes will have leading zeros. | Pacific Standard Time is "-08:00" |
zz | The time zone offset ("+" or "-" followed by the hour only). Single-digit hours will have a leading zero. For example, Pacific Standard Time is "-08" | Pacific Standard Time is "-08:00" |
epochS | Expects seconds counted from January 1, 1970 (midnight UTC/GMT), not counting leap seconds (in ISO 8601: 1970-01-01T00:00:00Z). |
|
epochMs | Expects miliseconds counted from January 1, 1970 (midnight UTC/GMT), not counting leap seconds (in ISO 8601: 1970-01-01T00:00:00Z). |
|