component
One part of a date on its own, a weekday name, a month name or a year, or a recurrence label such as Daily or Monthly.
4 component types: none a sibling also accepts.
The 4 component types
Each type's first registry sample, against every sibling's rule
| Type | Sample | Also accepted by |
|---|---|---|
Day of Week Name day_of_week · VARCHAR | Monday | — |
Full Month Name month_name · VARCHAR | January | — |
Periodicity periodicity · VARCHAR | Daily | — |
Calendar Year year · SMALLINT | 2024 | — |
Which component type is it?
No component type's rule accepts it.
Day of Week Name, Full Month Name and Periodicity carry no pattern or format, so they have no rule to ask.
Use it
Shell
printf '%s\n' 'Monday' 'Friday' > column.txt
finetype infer -f column.txt --mode columnDuckDB
SELECT ft_profile(v) FROM (VALUES ('Monday'), ('Friday')) t(v);No component type's rule accepts Friday.