The best way to determine the setup that provides the best performance is to perform your own tests. For example, try loading data and runnign queries with different numbers and sizes of nodes. This way, you will have results that are accurate based upon your own particular data and that way that it is stored … Read more
Here is a way, demo at SQL Fiddle CREATE TABLE Table1 (“id” int, “datetime” time, “name” varchar(1)) ; INSERT INTO Table1 (“id”, “datetime”, “name”) VALUES (1, ’11:10:01′, ‘A’), (1, ’11:10:02′, ‘A’), (1, ’11:10:05′, ‘B’), (1, ’11:12:02′, ‘A’), (1, ’11:12:10′, ‘A’), (2, ’11:13:02′, ‘B’), (2, ’11:13:06′, ‘A’), (1, ’11:14:01′, ‘A’), (1, ’11:14:02′, ‘B’), (1, ’11:14:05′, ‘A’) … Read more
This query: SELECT to_char(generate_series(0, 23) * interval ‘1 hour’ + ‘2019-01-01 00:00:00’::timestamp, ‘HH24:MI’) will return: 00:00 01:00 02:00 03:00 … 23:00 Just modify the format string for what you desire. 0 solved generate_series for every hour in hh24:mi:ss format