By default BigML accepts ISO 8601 time formats (YYYY-MM-dd) as well as a number of other common European and US formats, as seen in the table below. If none of the predefined formats in this table meets your needs, you can set your own format string using the Joda-time specification for datetime patterns.
Format Name | Example |
basic-date-time | 19690714T173639.592Z |
basic-date-time-no-ms | 19690714T173639Z |
basic-iso-date | 19690714Z |
basic-ordinal-date-time | 1969195T173639.592Z |
basic-ordinal-date-time-no-ms | 1969195T173639Z |
basic-t-time | T173639.592Z |
basic-t-time-no-ms | T173639Z |
basic-time | 173639.592Z |
basic-time-no-ms | 173639Z |
basic-week-date | 1969W291 |
basic-week-date-time | 1969W291T173639.592Z |
basic-week-date-time-no-ms | 1969W291T173639Z |
bigquery | 1969-07-14 17:36:39Z |
bigquery-alt | 1969-07-14 17:36:39 UTC |
bigquery-millisecond | 1969-07-14 17:36:39.592Z |
bigquery-alt-millisecond | 1969-07-14 17:36:39.592 UTC |
clock-minute | 5:36 PM |
clock-minute-nospace | 5:36PM |
clock-second | 5:36:39 PM |
clock-second-nospace | 5:36:39PM |
date | 1969-07-14 |
date-hour | 1969-07-14T17 |
date-hour-minute | 1969-07-14T17:36 |
date-hour-minute-second | 1969-07-14T17:36:39 |
date-hour-minute-second-fraction | 1969-07-14T17:36:39.592 |
date-hour-minute-second-fraction-with-solidus | 1969/07/14T17:36:39.592 |
date-hour-minute-second-ms | 1969-07-14T17:36:39.592 |
date-hour-minute-second-ms-with-solidus | 1969/07/14T17:36:39.592 |
date-hour-minute-second-with-solidus | 1969/07/14T17:36:39 |
date-hour-minute-with-solidus | 1969/07/14T17:36 |
date-hour-with-solidus | 1969/07/14T17 |
date-time | 1969-07-14T17:36:39.592Z |
date-time-no-ms | 1969-07-14T17:36:39Z |
date-time-no-ms-with-solidus | 1969/07/14T17:36:39Z |
date-time-with-solidus | 1969/07/14T17:36:39.592Z |
date-with-solidus | 1969/07/14 |
eu-date | 14/7/1969 |
eu-date-clock-minute | 14/7/1969 5:36 PM |
eu-date-clock-minute-nospace | 14/7/1969 5:36PM |
eu-date-clock-second | 14/7/1969 5:36:39 PM |
eu-date-clock-second-nospace | 14/7/1969 5:36:39PM |
eu-date-millisecond | 14/7/1969 17:36:39.592 |
eu-date-minute | 14/7/1969 17:36 |
eu-date-second | 14/7/1969 17:36:39 |
eu-ddate | 14.7.1969 |
eu-ddate-clock-minute | 14.7.1969 5:36 PM |
eu-ddate-clock-minute-nospace | 14.7.1969 5:36PM |
eu-ddate-clock-second | 14.7.1969 5:36:39 PM |
eu-ddate-clock-second-nospace | 14.7.1969 5:36:39PM |
eu-ddate-millisecond | 14.7.1969 17:36:39.592 |
eu-ddate-minute | 14.7.1969 17:36 |
eu-ddate-second | 14.7.1969 17:36:39 |
eu-sdate | 14-7-1969 |
eu-sdate-clock-minute | 14-7-1969 5:36 PM |
eu-sdate-clock-minute-nospace | 14-7-1969 5:36PM |
eu-sdate-clock-second | 14-7-1969 5:36:39 PM |
eu-sdate-clock-second-nospace | 14-7-1969 5:36:39PM |
eu-sdate-millisecond | 14-7-1969 17:36:39.592 |
eu-sdate-minute | 14-7-1969 17:36 |
eu-sdate-second | 14-7-1969 17:36:39 |
hour-minute | 17:36 |
hour-minute-second | 17:36:39 |
hour-minute-second-fraction | 17:36:39.592 |
hour-minute-second-ms | 17:36:39.592 |
iso-date | 1969-07-14Z |
iso-date-time | 1969-07-14T17:36:39.592Z |
iso-instant | 1969-07-14T17:36:39.592Z |
iso-local-date | 1969-07-14 |
iso-local-date-time | 1969-07-14T17:36:39.592 |
iso-local-time | 17:36:39.592 |
iso-offset-date | 1969-07-14Z |
iso-offset-date-time | 1969-07-14T17:36:39.592Z |
iso-offset-time | 17:36:39.592Z |
iso-ordinal-date | 1969-195Z |
iso-time | 17:36:39.592Z |
iso-week-date | 1969-W29-1Z |
iso-zoned-date-time | 1969-07-14T17:36:39.592Z |
mysql | 1969-07-14 17:36:39 |
no-t-date-hour-minute | 1969-7-14 17:36 |
odata-format | /Date(-14711000408)/ |
ordinal-date-time | 1969-195T17:36:39.592Z |
ordinal-date-time-no-ms | 1969-195T17:36:39Z |
rfc-1123-date-time | Mon, 14 Jul 1969 17:36:39 GMT |
rfc822 | Mon, 14 Jul 1969 17:36:39 +0000 |
t-time | T17:36:39.592Z |
t-time-no-ms | T17:36:39Z |
time | 17:36:39.592Z |
time-no-ms | 17:36:39Z |
timestamp | -14711000 |
timestamp-msecs | -14711000408 |
twitter-time | Mon Jul 14 17:36:39 +0000 1969 |
twitter-time-alt | 1969-7-14 17:36:39 +0000 |
twitter-time-alt-2 | 1969-7-14 17:36 +0000 |
twitter-time-alt-3 | Mon Jul 14 17:36 +0000 1969 |
us-date | 7/14/1969 |
us-date-clock-minute | 7/14/1969 5:36 PM |
us-date-clock-minute-nospace | 7/14/1969 5:36PM |
us-date-clock-second | 7/14/1969 5:36:39 PM |
us-date-clock-second-nospace | 7/14/1969 5:36:39PM |
us-date-millisecond | 7/14/1969 17:36:39.592 |
us-date-minute | 7/14/1969 17:36 |
us-date-second | 7/14/1969 17:36:39 |
us-sdate | 7-14-1969 |
us-sdate-clock-minute | 7-14-1969 5:36 PM |
us-sdate-clock-minute-nospace | 7-14-1969 5:36PM |
us-sdate-clock-second | 7-14-1969 5:36:39 PM |
us-sdate-clock-second-nospace | 7-14-1969 5:36:39PM |
us-sdate-millisecond | 7-14-1969 17:36:39.592 |
us-sdate-minute | 7-14-1969 17:36 |
us-sdate-second | 7-14-1969 17:36:39 |
week-date | 1969-W29-1 |
week-date-time | 1969-W29-1T17:36:39.592Z |
week-date-time-no-ms | 1969-W29-1T17:36:39Z |
weekyear-week | 1969-W29 |
weekyear-week-day | 1969-W29-1 |
year-month | 1969-07 |
year-month-day | 1969-07-14 |
other | Define your own format |