MeridianMERIDIAN

duration

A length of time written as an ISO 8601 duration: P, then years, months and days, then T and hours, minutes and seconds, or P and a number of weeks, and also the alternative form PYYYY-MM-DDThh:mm:ss. You'd meet it in iCalendar, XML Schema, the YouTube API and Google Calendar.

1 duration type: ISO 8601 Duration.

1 type

The duration type

ISO 8601 Durationiso_8601
INTERVALPT30M

Which duration type is it?

DuckDB cannot run ISO 8601 Duration's rule, so the box cannot say whether it accepts a value.

Use it

Shell
printf '%s\n' 'PT30M' 'PT1H30M' > column.txt
finetype infer -f column.txt --mode column
DuckDB
SELECT ft_profile(v) FROM (VALUES ('PT30M'), ('PT1H30M')) t(v);

No duration type's rule accepts PT1H30M.

Type Registry