sql - Redshift 将日期转换为 Unix 时间戳

Question

我在 Redshift 表中有一列日期。我希望输出采用 unix 时间戳的形式。
本质上，我想要这个问题的反面:How to convert epoch to datetime redshift?

有没有办法做到这一点？

Answer 1

您可以使用 EPOCH与 DATE_PART .

select date_part(epoch, date_column)
from tbl  

来自 documentation

The Amazon Redshift implementation of EPOCH is relative to 1970-01-01 00:00:00.000000 independent of the time zone where the server resides. You might need to offset the results by the difference in hours depending on the time zone where the server is located.