In order to get hour from Timestamp in postgresql we use Extract Keyword. Within the Extract keyword we have to mention HOUR as we are getting HOUR from timestamp
Let’s see how to
- Extract hour from Timestamp in Postgresql
- Create the column which extracts hour from timestamp column
With an example for both
Extract hour from Timestamp in Postgresql:
Within the Extract keyword we have to mention HOUR as we are getting hour from timestamp
SELECT EXTRACT (HOUR FROM TIMESTAMP '2011-11-22 13:30:15')
So the resultant HOUR will be
EXTRACT hour from Timestamp in column of Postgresql table:
We use table student_detail
Create the column which extracts HOUR from timestamp column in Postgresql:
We have created a column and stored hour from Birthdaytime column
SELECT *,EXTRACT (HOUR FROM Birthdaytime) AS HOUR FROM Student_detail
So the resultant table will be