CODEWITHSUNDEEP
sqlamazon-redshiftunix-timestamp
user1742188
user1742188

Reputation: 5083

Redshift convert dates to unix timestamps

I have a column of dates in a Redshift table. I would like the output to be in the form of unix timestamps. Essentially, I want the opposite of this question: How to convert epoch to datetime redshift?

Is there a way to do this?

Upvotes: 8

Views: 21036

Answers (2)

XaxD
XaxD

Reputation: 1538

Date_part is dead. Use extract() now --

SELECT extract(epoch from CURRENT_DATE)

Upvotes: 9

Vamsi Prabhala
Vamsi Prabhala

Reputation: 49260

You can just use EPOCH with DATE_PART.

select date_part(epoch, date_column)
from tbl

From the 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.

Upvotes: 8

Related Questions