[Solved] generate_series for every hour in hh24:mi:ss format

by


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