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
EXTRACT minute from Timestamp in column of Postgresql table:
We use table student_detail
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