How to convert date time into unix epoch value in

2019-02-08 00:40发布

问题:

How do I convert the following format to UNIX timestamps?

A value like: 01-02-2015 10:20 PM should be converted to: 1418273999000

I did try to_timestamp function but its not working for me.

回答1:

If your data is stored in a column called ts, in a table called data, do this:

select extract(epoch from ts) from data


回答2:

To add Joe's answer, you can use date_part, i think it's syntax is clearer than 'extract'.

select date_part('epoch', ts) from data;