time
A time of day with no date: hours and minutes, or hours, minutes and seconds, on a twelve-hour clock with AM or PM or on a twenty-four-hour clock, down to microseconds.
5 time types: 5 with a format string, none a sibling also accepts.
The 5 time types
2024-03-04 05:06:07 in each type's format, against every sibling's rule
| Type | Format | Writes it as | Also accepted by |
|---|---|---|---|
12-Hour Time (HH:MM AM/PM) hm_12h · TIME | %I:%M %p | 05:06 AM | — |
24-Hour Time (HH:MM) hm_24h · TIME | %H:%M | 05:06 | — |
12-Hour Time with AM/PM hms_12h · TIME | %I:%M:%S %p | 05:06:07 AM | — |
24-Hour Time (HH:MM:SS) hms_24h · TIME | %H:%M:%S | 05:06:07 | — |
ISO Time with Microseconds iso · TIME | %H:%M:%S.%f | 05:06:07.123456 | — |
Which time type is it?
1 of 5 time types accepts it.
| Type | Reads it as |
|---|---|
12-Hour Time (HH:MM AM/PM) hm_12h | 05:06:00 |
Use it
Shell
printf '%s\n' '05:06 AM' '05:06 AM' > column.txt
finetype infer -f column.txt --mode columnDuckDB
SELECT ft_profile(v) FROM (VALUES ('05:06 AM'), ('05:06 AM')) t(v);After 05:06 AM, one type remains: hm_12h.