Get Second from Timestamp in Postgresql

In order to get second from Timestamp in postgresql we use Extract Keyword. Within the Extract keyword we have to mention SECOND as we are getting SECOND from timestamp

Let’s see how to

  • Extract second from Timestamp in Postgresql
  • Create the column which extracts second from timestamp column

With an example for both

 

Extract second from Timestamp in Postgresql:

Within the Extract keyword we have to mention SECOND as we are getting second from timestamp

SELECT EXTRACT (SECOND FROM TIMESTAMP '2011-11-22 13:30:15')

So the resultant SECOND will be

Get Second from timestamp in postgresql in 2

 

EXTRACT second from Timestamp in column of Postgresql table:

We use table student_detail

Get Second from timestamp in postgresql in 1

 

Create the column which extracts SECOND from timestamp column in Postgresql

We have created a column and stored second from Birthdaytime column

SELECT *,EXTRACT (SECOND FROM Birthdaytime) AS SECOND FROM Student_detail

So the resultant table will be

Get Second from timestamp in postgresql in 3