Re: Timestamp conversion Error in dynamic sql script

[Greg Sabino Mullane]

>
> 1. Declare start_date as DATE when you want to add days with date + int
> 2. Keep TIMESTAMP and use start_date + make_interval(days => i)
>

Also

0. Use TIMESTAMPTZ not TIMESTAMP

Cheers,
Greg