How to generate time series data in Postgres

Simple series

SELECT * FROM generate_series(1,3);

Date series

SELECT * from generate_series('2024-10-13 00:00:00'::timestamp, 
	'2024-10-13 23:00:00'::timestamp, '1 hour'::interval);

SQL Output