Default supported datetime formats

By default, Tonic Textual supports the following datetime formats.

Date only formats

Format	Example value
yyyy/M/d	2024/1/17
yyyy-M-d	2024-1-17
yyyyMMdd	20240117
yyyy.M.d	2024.1.17
yyyy, MMM d	2024, Jan 17
yyyy-M	2024-1
yyyy/M	2024/1
d/M/yyyy	17/1/2024
d-MMM-yyyy	17-Jan-2024
dd-MMM-yy	17-Jan-24
d-M-yyyy	17-1-2024
d/MMM/yyyy	17/Jan/2024
d MMMM yyyy	17 January 2024
d MMM yyyy	17 Jan 2024
d MMMM, yyyy	17 January, 2024
ddd, d MMM yyyy	Wed, 17 Jan 2024
M/d/yyyy	1/17/2024
M/d/yy	1/17/24
M-d-yyyy	1-17-2024
MMddyyyy	01172024
MMMM d, yyyy	January 17, 2024
MMM d, ''yy	Jan 17, '24
MM-yyyy	01-2024
MMMM, yyyy	January, 2024

Date and time formats

Format	Example value
yyyy-M-d HH:mm	2024-1-17 15:45
d-M-yyyy HH:mm	17-1-2024 15:45
MM-dd-yy HH:mm	01-17-24 15:45
d/M/yy HH:mm:ss	17/1/24 15:45:30
d/M/yyyy HH:mm:ss	17/1/2024 15:45:30
yyyy/M/d HH:mm:ss	2024/1/17 15:45:30
yyyy-M-dTHH:mm:ss	2024-1-17T15:45:30
yyyy/M/dTHH:mm:ss	2024/1/17T15:45:30
yyyy-M-d HH:mm:ss'Z'	2024-1-17 15:45:30Z
yyyy-M-d'T'HH:mm:ss'Z'	2024-1-17T15:45:30Z
yyyy-M-d HH:mm:ss.fffffff	2024-1-17 15:45:30.1234567
yyyy-M-dd HH:mm:ss.FFFFFF	2024-1-17 15:45:30.123456
yyyy-M-dTHH:mm:ss.fff	2024-1-17T15:45:30.123

Time only formats

Format	Example value
HH:mm	15:45
HH:mm:ss	15:45:30
HHmmss	154530
hh:mm:ss tt	03:45:30 PM
HH:mm:ss'Z'	15:45:30Z