MeridianMERIDIAN

period

A stretch of the calendar named by a label rather than its dates: a calendar quarter or a fiscal year. You'd meet them in earnings data, SEC filings, budget documents and annual reports.

2 period types: none a sibling also accepts, 2 that decompose into parts.

2 types

The 2 period types

Each type's first registry sample, against every sibling's rule

TypeSampleAlso 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.

TypeReads it as
Fiscal Year fiscal_year2024

Use it

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

After FY24, one type remains: fiscal_year.

Type Registry