offset
3 offset types: none a sibling also accepts.
The 3 offset types
Each type's first registry sample, against every sibling's rule
| Type | Sample | Also accepted by |
|---|---|---|
IANA Timezone Name iana · VARCHAR | America/New_York | — |
Timezone Abbreviation timezone_abbreviation · VARCHAR | EST | — |
UTC Offset utc · VARCHAR | UTC +05:00 | — |
Which offset type is it?
1 of 3 offset types accepts it.
| Type | Reads it as |
|---|---|
IANA Timezone Name iana | America/New_York |
Use it
CLI · DuckDB
$ printf '%s\n' 'America/New_York' 'Europe/London' > column.txt
$ finetype infer -f column.txt --mode column
SELECT ft_profile(v) FROM (VALUES ('America/New_York'), ('Europe/London')) t(v);After Europe/London, one type remains: iana.