postgresql - Redshift : How to cast integer with year into a date?

Question

假设用户尝试将数字(出生年份)转换为日期。

select year_of_birth, cast(year_of_birth as date) from visit_occurrence 

并得到这个错误:

cannot cast type smallint to date

什么是正确的方法？例如，cast(cast(YOB as string)+'-01-01' as date) 也不起作用。

Answer 1

使用

select year_of_birth, to_date(cast(year_of_birth as text), 'YYYY') from visit_occurrence ;