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 |
Comments