Generic Import Time/Date patterns
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). | Â |
Â
Â