CODEWITHSUNDEEP
sqlamazon-redshiftunix-timestamp
user1742188
user1742188

Reputation: 5133

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: 21228

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: 49270

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