Submit a help request

What date and time formats are supported by DataHero?

There are several date, time, and date+time formats that DataHero supports. The following are some common formats used, but attached to this is a full list of all the formats DataHero supports.

Supported delimiters: . (period), / (forward slash), and - (hyphen)

Date Formats

DD-MM-YYYY

15-01-2014

MM-DD-YYYY

01-15-2014

YYYY-MM-DD 

2014-01-15

DDD, MMM DD, YYYY

Wed, Jan 15, 2014

MMM DD, YYYY

Jan 15, 2014

 

Time Formats

HH:MM:SS

14:00:00

HH:MM:SS (AM/PM)

02:00:00 PM

HH:MM

14:00

HH:MM (AM/PM)

02:00 PM


Date + Time Formats
 

UTC (seconds since epoch)

1415920000

MM-DD-YY hh:mm:ss

01-15-14 14:00:00

MM-DD-YY hh:mm:ss (am/pm)

01-15-14 02:00:00 PM

MM-DD-YY hh:mm

01-15-14 14:00

MM-DD-YY hh:mm (am/pm)

01-15-14 02:00 PM

YYYY-MM-DDThh:mm:ss

01-15-14T14:00:00

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk