How to extract hour from query in postgres

SELECT to_char(now(), 'HH24:MI:SS')  hour_minute_second

The following should work

select extract(hour from observationtime) from smartvakt_device_report