T
Tom 234

Posted on 26th April 2024|161 views

0
votes

Postgres Extract Epoch

How to extract Epoch in PostgreSQL?

Answers
P
Surya kumar

Posted on 26th April 2024

Extracting Epoch is a simple process for different versions of PostgreSQL by using this command:

SELECT extract(EPOCH FROM TIMESTAMP '1970-01-01'::Timestamp at time zone ‘GMT’);

As this will extract Epoch from Timestamp.

 

Write your answer

STILL GOT QUERIES?

Get a Live FREE Demo
  • Explore the trending and niche courses and learning maps
  • Learn about tuition fee, payment plans, and scholarships
  • Get access to webinars and self-paced learning videos