How To Convert Date Timestamp Value To Numeric And Numeric To Timestamp ...

Only 3.9% of viewers are subscribing to my channel 😓.

I request you to please give click on Subscribe button.

It really helps me grow 😢.

How To Convert Date Timestamp Value To Numeric And Numeric To Timestamp In PostgreSQL Using pgAdmin4


select cast(extract(epoch from now()) as integer);


select to_timestamp(1591369682);



-- Purpose is to Cast/ Convert A Date value (timestap) to Number and Vice-Versa


SELECT CAST(EXTRACT(EPOCH FROM CURRENT_TIMESTAMP) AS INTEGER);

SELECT CURRENT_TIMESTAMP;

SELECT TO_TIMESTAMP(1591372301);

-- 1591372301