Redshift convert dates to unix timestamps

Question

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?

can you show the format of your dates?

Vamsi Prabhala
– Vamsi Prabhala

2017-06-09 16:23:02 +00:00
Commented Jun 9, 2017 at 16:23 — Vamsi Prabhala
– Vamsi Prabhala, Commented Jun 9, 2017 at 16:23

XaxD · Accepted Answer · 2021-11-18 09:59:53Z

9

Date_part is dead. Use extract() now --

SELECT extract(epoch from CURRENT_DATE)

answered Nov 18, 2021 at 9:59

XaxD

1,54815 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vamsi Prabhala · Accepted Answer · 2017-06-09 16:40:53Z

8

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.

answered Jun 9, 2017 at 16:40

Vamsi Prabhala

49.4k4 gold badges41 silver badges64 bronze badges

Collectives™ on Stack Overflow

Redshift convert dates to unix timestamps

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related