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 Java DateTimeFormatter specification for datetime patterns.
| Name | Example | Format |
|---|---|---|
| basic-date-time | 19690714T173639.592Z | YYYYMMdd'T'HHmmss.SSSXX |
| basic-date-time-no-ms | 19690714T173639Z | YYYYMMdd'T'HHmmssXX |
| basic-iso-date | 19690714Z | YYYYMMddXX |
| basic-ordinal-date-time | 1969195T173639.592Z | YYYYDDD'T'HHmmss.SSSXX |
| basic-ordinal-date-time-no-ms | 1969195T173639Z | YYYYDDD'T'HHmmssXX |
| basic-t-time | T173639.592Z | 'T'HHmmss.SSSXX |
| basic-t-time-no-ms | T173639Z | 'T'HHmmssXX |
| basic-time | 173639.592Z | HHmmss.SSSXX |
| basic-time-no-ms | 173639Z | HHmmssXX |
| basic-week-date | 1969W291 | xxxx'W'wwe |
| basic-week-date-time | 1969W291T173639.592Z | xxxx'W'wwe'T'Hmmss.SSSXX |
| basic-week-date-time-no-ms | 1969W291T173639Z | xxxx'W'wwe'T'HmmssXXX |
| bigquery | 1969-07-14 17:36:39Z | Y-M-d H:m:sXXX |
| bigquery-alt | 1969-07-14 17:36:39 UTC | Y-M-d H:m:s z |
| bigquery-alt-millisecond | 1969-7-14 17:36:39.592000 UTC | Y-M-d H:m:s.SSSSSS z |
| bigquery-millisecond | 1969-7-14 17:36:39.592000Z | Y-M-d H:m:s.SSSSSSXXX |
| clock-minute | 5:36 PM | h:m a |
| clock-minute-nospace | 5:36PM | h:ma |
| clock-second | 5:36:39 PM | h:m:s a |
| clock-second-nospace | 5:36:39PM | h:m:sa |
| date | 1969-07-14 | Y-M-d |
| date-hour | 1969-07-14T17 | YYYY-MM-dd'T'H |
| date-hour-minute | 1969-07-14T17:36 | YYYY-MM-dd'T'H:mm |
| date-hour-minute-second | 1969-07-14T17:36:39 | YYYY-MM-dd'T'H:mm:ss |
| date-hour-minute-second-fraction | 1969-07-14T17:36:39.592 | YYYY-MM-dd'T'H:mm:ss.SSS |
| date-hour-minute-second-fraction-with-solidus | 1969/07/14T17:36:39.592 | YYYY/MM/dd'T'H:mm:ss.SSS |
| date-hour-minute-second-ms | 1969-07-14T17:36:39.592 | YYYY-MM-dd'T'HH:mm:ss.SSS |
| date-hour-minute-second-ms-with-solidus | 1969/07/14T17:36:39.592 | YYYY/MM/dd'T'HH:mm:ss.SSS |
| date-hour-minute-second-with-solidus | 1969/07/14T17:36:39 | YYYY/MM/dd'T'H:mm:ss |
| date-hour-minute-with-solidus | 1969/07/14T17:36 | YYYY/MM/dd'T'H:mm |
| date-hour-with-solidus | 1969/07/14T17 | YYYY/MM/dd'T'H |
| date-time | 1969-07-14T17:36:39.592Z | YYYY-MM-dd'T'H:mm:ss.SSSXXX |
| date-time-no-ms | 1969-07-14T17:36:39Z | YYYY-MM-dd'T'H:mm:ssXXX |
| date-time-no-ms-with-solidus | 1969/07/14T17:36:39Z | YYYY/MM/dd'T'H:mm:ssXXX |
| date-time-with-solidus | 1969/07/14T17:36:39.592Z | YYYY/MM/dd'T'H:mm:ss.SSSXXX |
| date-with-solidus | 1969/07/14 | YYYY/MM/dd |
| elasticsearch-nanos | 1969-07-14T17:36:39.592000Z | YYYY-MM-dd'T'HH:mm:ss.SSSSSSZ |
| eu-date | 14/7/1969 | d/M/Y |
| eu-date-clock-minute | 14/7/1969 5:36 PM | d/M/Y h:m a |
| eu-date-clock-minute-nospace | 14/7/1969 5:36PM | d/M/Y h:ma |
| eu-date-clock-second | 14/7/1969 5:36:39 PM | d/M/Y h:m:s a |
| eu-date-clock-second-nospace | 14/7/1969 5:36:39PM | d/M/Y h:m:sa |
| eu-date-millisecond | 14/7/1969 17:36:39.592 | d/M/Y H:m:s.SSS |
| eu-date-minute | 14/7/1969 17:36 | d/M/Y H:m |
| eu-date-second | 14/7/1969 17:36:39 | d/M/Y H:m:s |
| eu-ddate | 14.7.1969 | d.M.Y |
| eu-ddate-clock-minute | 14.7.1969 5:36 PM | d.M.Y h:m a |
| eu-ddate-clock-minute-nospace | 14.7.1969 5:36PM | d.M.Y h:ma |
| eu-ddate-clock-second | 14.7.1969 5:36:39 PM | d.M.Y h:m:s a |
| eu-ddate-clock-second-nospace | 14.7.1969 5:36:39PM | d.M.Y h:m:sa |
| eu-ddate-millisecond | 14.7.1969 17:36:39.592 | d.M.Y H:m:s.SSS |
| eu-ddate-minute | 14.7.1969 17:36 | d.M.Y H:m |
| eu-ddate-second | 14.7.1969 17:36:39 | d.M.Y H:m:s |
| eu-sdate | 14-7-1969 | d-M-Y |
| eu-sdate-clock-minute | 14-7-1969 5:36 PM | d-M-Y h:m a |
| eu-sdate-clock-minute-nospace | 14-7-1969 5:36PM | d-M-Y h:ma |
| eu-sdate-clock-second | 14-7-1969 5:36:39 PM | d-M-Y h:m:s a |
| eu-sdate-clock-second-nospace | 14-7-1969 5:36:39PM | d-M-Y h:m:sa |
| eu-sdate-millisecond | 14-7-1969 17:36:39.592 | d-M-Y H:m:s.SSS |
| eu-sdate-minute | 14-7-1969 17:36 | d-M-Y H:m |
| eu-sdate-second | 14-7-1969 17:36:39 | d-M-Y H:m:s |
| hour-minute | 17:36 | H:mm |
| hour-minute-second | 17:36:39 | H:mm:ss |
| hour-minute-second-fraction | 17:36:39.592 | H:mm:ss.SSS |
| hour-minute-second-ms | 17:36:39.592 | H:mm:ss.SSS |
| iso-date | 1969-07-14Z | Y-M-dXXX |
| iso-date-time | 1969-07-14T17:36:39.592Z | Y-M-d'T'HH:mm:ss.SSSXXX |
| iso-instant | 1969-07-14T17:36:39.592Z | Y-M-d'T'HH:mm:ss.SSSXXX |
| iso-local-date | 1969-07-14 | Y-M-d |
| iso-local-date-time | 1969-07-14T17:36:39.592 | Y-M-d'T'HH:mm:ss |
| iso-local-time | 17:36:39.592 | HH:mm:ss.SSS |
| iso-offset-date | 1969-07-14Z | Y-M-dXXX |
| iso-offset-date-time | 1969-07-14T17:36:39.592Z | Y-M-d'T'HH:mm:ss.SSSXXX |
| iso-offset-time | 17:36:39.592Z | HH:mm:ss.SSSXXX |
| iso-ordinal-date | 1969-195Z | YYYY-DDDXX |
| iso-time | 17:36:39.592Z | HH:mm:ss.SSSXXX |
| iso-week-date | 1969-W29-1Z | xxxx-'W'ww-ez |
| iso-zoned-date-time | 1969-07-14T17:36:39.592Z | Y-M-d'T'HH:mm:ss.SSSXXX |
| mysql | 1969-07-14 17:36:39 | YYYY-MM-dd H:mm:ss |
| no-t-date-hour-minute | 1969-7-14 17:36 | YYYY-MM-dd H:m |
| odata-format | /Date(-14711000408)/ | |
| ordinal-date-time | 1969-195T17:36:39.592Z | YYYY-DDD'T'H:mm:ss.SSSXXX |
| ordinal-date-time-no-ms | 1969-195T17:36:39Z | YYYY-DDD'T'H:mm:ssXXX |
| rfc-1123-date-time | Mon, 14 Jul 1969 17:36:39 GMT | EEE, dd MMM YYYY HH:mm:ss z |
| rfc822 | Mon, 14 Jul 1969 17:36:39 +0000 | EEE, dd MMM YYYY HH:mm:ss ZZZZ |
| t-time | T17:36:39.592Z | 'T'HH:mm:ss.SSSXXX |
| t-time-no-ms | T17:36:39Z | 'T'HH:mm:ssXXX |
| time | 17:36:39.592Z | HH:mm:ss.SSSXXX |
| time-no-ms | 17:36:39Z | HH:mm:ssXXX |
| timestamp | -14711000 | |
| timestamp-msecs | -14711000408 | |
| twitter-time | Mon Jul 14 17:36:39 +0000 1969 | E MMM d H:m:s Z Y |
| twitter-time-alt | 1969-7-14 17:36:39 +0000 | Y-M-d H:m:s Z |
| twitter-time-alt-2 | 1969-7-14 17:36 +0000 | Y-M-d H:m Z |
| twitter-time-alt-3 | Mon Jul 14 17:36 +0000 1969 | E MMM d H:m Z Y |
| us-date | 7/14/1969 | M/d/Y |
| us-date-clock-minute | 7/14/1969 5:36 PM | M/d/Y h:m a |
| us-date-clock-minute-nospace | 7/14/1969 5:36PM | M/d/Y h:ma |
| us-date-clock-second | 7/14/1969 5:36:39 PM | M/d/Y h:m:s a |
| us-date-clock-second-nospace | 7/14/1969 5:36:39PM | M/d/Y h:m:sa |
| us-date-millisecond | 7/14/1969 17:36:39.592 | M/d/Y H:m:s.SSS |
| us-date-minute | 7/14/1969 17:36 | M/d/Y H:m |
| us-date-second | 7/14/1969 17:36:39 | M/d/Y H:m:s |
| us-sdate | 7-14-1969 | M-d-Y |
| us-sdate-clock-minute | 7-14-1969 5:36 PM | M-d-Y h:m a |
| us-sdate-clock-minute-nospace | 7-14-1969 5:36PM | M-d-Y h:ma |
| us-sdate-clock-second | 7-14-1969 5:36:39 PM | M-d-Y h:m:s a |
| us-sdate-clock-second-nospace | 7-14-1969 5:36:39PM | M-d-Y h:m:sa |
| us-sdate-millisecond | 7-14-1969 17:36:39.592 | M-d-Y H:m:s.SSS |
| us-sdate-minute | 7-14-1969 17:36 | M-d-Y H:m |
| us-sdate-second | 7-14-1969 17:36:39 | M-d-Y H:m:s |
| week-date | 1969-W29-1 | xxxx-'W'ww-e |
| week-date-time | 1969-W29-1T17:36:39.592Z | xxxx-'W'ww-e'T'H:mm:ss.SSSXXX |
| week-date-time-no-ms | 1969-W29-1T17:36:39Z | xxxx-'W'ww-e'T'H:mm:ssXXX |
| weekyear-week | 1969-W29 | xxxx-'W'ww |
| weekyear-week-day | 1969-W29-1 | xxxx-'W'ww-e |
| year-month | 1969-07 | YYYY-MM |
| year-month-day | 1969-07-14 | YYYY-MM-dd |