How to convert a query to PostgreSQL?

Question

MySQL

Good day to all. I have a table with fields - (id, temp, hum, date). An entry is added to it every 5 minutes. There is a query that displays temp, hum and date for every hour for the current day. That is, 24 records.

SELECT temp, hum, date 
FROM meteo_temp0 
WHERE DATE(date) = CURDATE() 
GROUP BY EXTRACT(HOUR FROM date) 
ORDER BY EXTRACT(HOUR FROM date)

Help to convert it to PostgreSQL. I am attaching an image of the table for clarity.
Tried like this:

SELECT temp, hum, date 
FROM meteo_temp0 
WHERE DATE(date) = CURRENT_DATE 
GROUP BY EXTRACT(HOUR FROM(date)) 
ORDER BY EXTRACT(HOUR FROM(date))

Gives an error message:

column "meteo_temp0.temp" must appear in the GROUP BY clause or be used in an aggregate function

Thanks in advance.

Answer 1

use the date_part function
pgcookbook.ru/programming/date_and_time.html