I have a table as
create table my_table(created timestamp);
The value which I want to insert is – 1706812200000
But it is in milliseconds. I want to convert it into 2024-04-30 16:48:02.079519 format.
I tried –
INSERT INTO my_table (created) VALUES (TO_TIMESTAMP(1706812200000::double precision/1000));
It gave me 2024-02-02 00:00:00
I want something like
2024-04-30 16:50:26.037643
New contributor
Neha Kumari is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.