Date Format#
Both for formatting as well as parsing dates, date formats are specified using a date format string.
These consist of various tokens that indicate where a certain part of the date is to be placed or expected.
Dataloaders Facets.json#
For the input_format_string
used in the facets.json
file for Dataloaders, the python date format is used.
Note: This also applies to the Time format
option exposed as part of the Map to labels`
step when adding Data Sources from the UI (e.g. for Excel, CSV, and so on).
Reference: See http://strftime.org/ for reference information regarding the supported directives.
Common Format Strings#
The following table lists common format strings which are often used in data integration projects:
Example |
Format String |
Description |
---|---|---|
|
|
ISO 8601 format with date and time including microseconds |
|
|
ISO 8601 format with date and time |
|
|
ISO 8601 format with date only |
Reference#
The following table lists all supported directives which can be used in format strings.
The example column is based on the sample string 2013-06-24T15:21:56.087821
:
Directive |
Meaning |
Example |
---|---|---|
|
Month as a decimal number [01,12]. |
|
|
Locale’s abbreviated month name. |
|
|
Locale’s full month name. |
|
|
Day of the month as a decimal number [01,31]. |
|
|
Day of the year as a decimal number [001,366]. |
|
|
Weekday as a decimal number [0(Sunday),6]. |
|
|
Locale’s abbreviated weekday name. |
|
|
Locale’s full weekday name. |
|
|
Year without century as a decimal number [00,99]. |
|
|
Year with century as a decimal number. |
|
|
Locale’s equivalent of either AM or PM. |
|
|
Hour (24-hour clock) as a decimal number [00,23]. |
|
|
Hour (12-hour clock) as a decimal number [01,12]. |
|
|
Minute as a decimal number [00,59]. |
|
|
Second as a decimal number [00,61]. |
|
|
Microsecond as a decimal number [0,999999], zero-padded on the left. |
|
|
A literal ‘%’ character. |
|