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

Details

Description

#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
--------------------------------------------------
Facebook - https://www.facebook.com/sonu.babu.5872682/
Instagram - https://www.instagram.com/akkubakku007/
google+ - https://plus.google.com/u/0/116728183002228924227
Blog - https://knowledge360blog.blogspot.in/

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