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

PrimitiveDescriptionExamples

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