period
2 period types: none a sibling also accepts, 2 that decompose into parts.
The 2 period types
Each type's first registry sample, against every sibling's rule
| Type | Sample | Also accepted by |
|---|---|---|
Fiscal Year fiscal_year · VARCHAR | FY2024 | — |
Calendar Quarter quarter · DATE | Q1 2024 | — |
Which period type is it?
1 of 2 period types accepts it.
| Type | Reads it as |
|---|---|
Fiscal Year fiscal_year | 2024 |
Use it
CLI · DuckDB
$ printf '%s\n' 'FY2024' 'FY24' > column.txt
$ finetype infer -f column.txt --mode column
SELECT ft_profile(v) FROM (VALUES ('FY2024'), ('FY24')) t(v);After FY24, one type remains: fiscal_year.