Column medicare._ps.year

Overview of column year in table medicare._ps

Table

medicare._ps

Qualified name

medicare._ps.year

Datatype

string

Column type

copied

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)