4 ms·
Works in PostgreSQL 9.6.1 postgres> SELECT extract(epoch from to_timestamp('2037-11-13 10:20:19', 'YYYY-MM-DD hh24:mi:ss')); date_part ------------
by Manozco 10y ago
Works in PostgreSQL 9.6.1
postgres> SELECT extract(epoch from to_timestamp('2037-11-13 10:20:19', 'YYYY-MM-DD hh24:mi:ss'));
date_part
------------
2141720419
(1 row)
postgres> SELECT extract(epoch from to_timestamp('2039-11-13 10:20:19', 'YYYY-MM-DD hh24:mi:ss'));
date_part
------------
2204792419
(1 row)