Date and Time Formats
Rowboat automatically detects the following date and time formats. Additional timestamps formatted in strptime date notation are also supported when manually entered using the “Set Format” option for the column.
Note: Rowboat does not currently support non zero-padded (%-
) time formats.
Example | Format |
---|---|
1972 | %Y |
11:00:00 AM | %H:%M:%S %p |
January 2021 | %B %Y |
Jul 1, 2004 | %b %d, %Y |
2011-11-07 | %Y-%m-%d |
12/04/2017 | %m/%d/%Y |
12/04/17 | %m/%d/%y |
11/4/2011 11:04 | %m/%d/%Y %H:%M |
11/4/11 11:04 | %m/%d/%y %H:%M |
9/1/2012 12:07 AM | %m/%d/%Y %H:%M %p |
9/1/12 12:07 AM | %m/%d/%y %H:%M %p |
9/1/12 12:07:03 AM | %m/%d/%y %H:%M:%S %p |
9/1/2012 12:07:03 AM | %m/%d/%Y %H:%M:%S %p |
2022-10-10 10:17:45 | %Y-%m-%d %H:%M:%S |
2022-10-10 10:17:45.59 | %Y-%m-%d %H:%M:%E*S |
2022-10-10 10:17:45 UTC | %Y-%m-%d %H:%M:%S %Z |
2022-10-10 10:17:45.59 UTC | %Y-%m-%d %H:%M:%E*S %Z |
2023-05-30T16:51:36.770Z | %Y-%m-%dT%H:%M:%S.%fZ |
2023-05-30T16:51:36Z | %Y-%m-%dT%H:%M:%SZ |
2023-05-30T16:51:36 | %Y-%m-%dT%H:%M:%S.%f |
2023-05-30T16:51:36 | %Y-%m-%dT%H:%M:%S |