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