How to convert a timestamp to an integer (Unix epoch) in Postgres

Question

I have a string "2016-10-25T00:14:30.000" in PostgreSQL.

I want to convert the timestamp to an integer, e.g: 1477354441

And I want to add custom minutes to that value, e.g. 1477354441+544(minutes) = 1477387081

How to achieve this in PostgreSQL?

Vesa Karjalainen · Accepted Answer · 2016-10-25 10:24:28Z

12

SELECT EXTRACT(EPOCH FROM TIMESTAMP '2016-10-25T00:14:30.000');

SELECT EXTRACT(EPOCH FROM TIMESTAMP '2016-10-25T00:14:30.000' + INTERVAL '544 min');

answered Oct 25, 2016 at 10:24

Vesa Karjalainen

1,1058 silver badges16 bronze badges

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

1 Comment

nice, it will help

Paul Maxwell · Accepted Answer · 2016-10-25 10:25:21Z

0

Try this combination of two functions

SELECT 
extract(epoch from to_timestamp('2016-10-25T00:14:30.000','yyyy-MM-ddTHH24:mi:ss.ms'))

answered Oct 25, 2016 at 10:17

Paul Maxwell

35.7k4 gold badges39 silver badges55 bronze badges