logo-MindMajix
T
Tom 234

Posted on 20th June 2024|162 views

0
votes

Postgres Extract Epoch

How to extract Epoch in PostgreSQL?

1 answers
Answers
P
Surya kumar

Posted on 20th June 2024| views

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
Name
Course *
Email *
Phone Number