Home > postgresql > postgresql create rows for date from start date to end date

postgresql create rows for date from start date to end date Edit

Murugan Andezuthu Dharmaratnam | 01 February 2022 | 727

how to create rows for each date from start date to end date in postgresql

Sample Code

select generate_series(
        '2022-02-01'::date, 
        '2022-02-07'::date, '1 day'
    )::date as transactiondate, 'hello' as world

Output