Get Minute from Timestamp in Postgresql

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

Let’s see how to

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

With an example for both

Extract minute from Timestamp in Postgresql:

Within the Extract keyword we have to mention MINUTE as we are getting minute from timestamp

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

So the resultant MINUTE will be

Get Minute from timestamp in Postgresql 2

 

EXTRACT minute from Timestamp in column of Postgresql table:

We use table student_detail

Get Minute from timestamp in Postgresql 1

 

Create the column which extracts MINUTE from timestamp column in Postgresql

We have created a column and stored minute from Birthdaytime column

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

So the resultant table will be

Get Minute from timestamp in Postgresql 3

 

                                                                                                       

Author

  • Sridhar Venkatachalam

    With close to 10 years on Experience in data science and machine learning Have extensively worked on programming languages like R, Python (Pandas), SAS, Pyspark.