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
2014-12-17 09:11:22.635 -06:00	%yyyy-%MM-%dd %HH:%mm:%ss.%fff %z

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
z	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"
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).