Both for formatting as well as parsing date, 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.
Note: for the "input_format_string" used in the facets.json file for Dataloaders (see Data Loader Facet Config Reference) the python date format is used. See http://strftime.org/ for reference on the supported directives). This also applies to the "Time format" option exposed as part of the "Map to facets" step when adding Data Sources from the UI (e.g. for Excel, CSV, ...)
Common Format Strings
The following table lists common format strings which are often used in data integration projects.
Example | Format String | Description |
---|---|---|
2013-06-21T12:22:06.376144 | YYYY-MM-DDTHH:mm:ss.SSS | ISO 8601 format with date and time including microseconds |
2013-06-21T12:22:06 | YYYY-MM-DDTHH:mm:ss | ISO 8601 format with date and time |
2013-06-21 | YYYY-MM-DD | 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 |
---|---|---|
MM | Month as a decimal number [01,12]. | 06 |
MMM | Locale’s abbreviated month name. | Jun |
MMMM | Locale’s full month name. | June |
DD | Day of the month as a decimal number [01,31]. | 24 |
DDDD | Day of the year as a decimal number [001,366]. | 175 |
d | Weekday as a decimal number [0(Sunday),6]. | 1 |
ddd | Locale’s abbreviated weekday name. | Mon |
dddd | Locale’s full weekday name. | Monday |
YY | Year without century as a decimal number [00,99]. | 13 |
YYYY | Year with century as a decimal number. | 2013 |
A | Locale’s equivalent of either AM or PM. | PM |
HH | Hour (24-hour clock) as a decimal number [00,23]. | 15 |
hh | Hour (12-hour clock) as a decimal number [01,12]. | 03 |
mm | Minute as a decimal number [00,59]. | 21 |
ss | Second as a decimal number [00,61]. | 56 |
SSS | Microsecond as a decimal number [0,999999], zero-padded on the left. | 087821 |
%% | A literal ‘%’ character. | %% |