Handling DATEADD in Postgres

Here's a link that compares mssql's DATEADD function to an equivalent method in Postgres.


Essentially the following work:

d1.tran_dts + cast('-6 months' as interval), d1.tran_dts + cast('1 year' as interval)

select '2004-2-29'::date + cast('1 years' as interval)
select '2004-2-29'::date + cast('-3 months' as interval)
select '2004-2-29'::date + cast('2 days' as interval)