Column medicare.qc_adm_union.year

Overview of column year in table medicare.qc_adm_union

Table	medicare.qc_adm_union
Qualified name	medicare.qc_adm_union.year
Datatype	INT
Column type	computed

Expressions

SELECT (CASE WHEN "year"::int < 20 THEN (2000 + "year"::int) WHEN (20 < "year"::int AND "year"::int < 100) THEN (1900 + "year"::int) WHEN "year" IS NULL THEN 2000 ELSE "year"::int END)