How to extract hour from query in postgres April 7, 2023 by Tarik The following should work select extract(hour from observationtime) from smartvakt_device_report