'Epoch to timeStamp without the timezone

I input the epoch 1635759368000 and want to convert to regular timestamp

select to_timestamp(1635759368000/1000)

Gives me an output of

2021-11-01 05:36:08.000 -0400

But I just want

2021-11-01 05:36:08.000

How would I do this?

sqlpostgresqltimestampepochdate-conversion


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions