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

#knowledge360 #akramsohail #akramsohailproject
You Are Hearty Welcomed To My Channel Knowledge 360.
Here I post technical videos, mainly related to computer science and programming.
I am posting project videos with coding explanations. I make tutorial videos on Technical Topics.
Stay Connected, Stay Tuned, Study Smart.

- Knowledge 360 ( Akram Sohail )

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 😢.

Please Like, Comment, and Subscribe to my channel. ❤

Follow me on Social Media
--------------------------------------------------

Topics
---------
Oracle
MySQL
PostgreSQL
SQL Server
PHP
C
C++
Python
Java
JavaScript
HTML/CSS
jQuery
Ajax
Bootstrap
Angular
Linux
Ubuntu
Windows
Miscellaneous

Description
------------------
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