SQLize Online / PHPize Online  /  SQLtest Online

create table tbl (id int, name varchar, start_date date, end_date date); insert into tbl values (1, 'Rahul', '01/01/2021', '06/01/2021'); select * from tbl; WITH RECURSIVE records AS ( select id, name, start_date, end_date from tbl union select tbl2.id, tbl2.name, tbl2.start_date, tbl2.end_date from tbl tbl2 join records on records.start_date <= tbl2.end_date ) select * from records; SELECT date_trunc('day', dd):: date FROM generate_series ( '2007-02-01'::timestamp , '2008-04-01'::timestamp , '1 day'::interval) dd ;