Convert date from long time postgres

SELECT *, to_timestamp(time_in_milli_sec / 1000) FROM mytable

sql postgresql time

SELECT timestamp 'epoch' + time_in_millisec * interval '1 ms'FROM   mytable;

sql postgresql time

For milliseconds

SELECT timestamp 'epoch' + proyecto.fecha_inicio * interval '1 ms'from proyecto.proyectowhere proyecto.fecha_inicio is not null

For seconds

SELECT TIMESTAMP WITH TIME ZONE 'epoch' + 982384720 * INTERVAL '1 second';

Line: .. "Here is how you can convert an epoch value back to a time stamp"..

CodeHunter