subtracting from a date

From: Jay Vee <jvsrvcs(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: subtracting from a date
Date: 2014-02-06 17:25:00
Message-ID: CADq_mb8CumMGtq23t0-Bj8JeN-X-Qe4t-qQYmWucqLzCLABsRg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have reviewed working with dates documentation but some things are not
clear and I cannot get an example to work for what I need.

I am passing a date into a stored function like '2013-04-01'

The stored function accepts this string as a date type.

Within the function, I need to:

1. subtract one year from this date into another date type
2. subtract one month from this date into another date type
3. subtract one day from this date into another date type

Are there any examples of this? This is not a timestamp type, but a date
type.

thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2014-02-06 17:31:06 Re: subtracting from a date
Previous Message Michael Sacket 2014-02-06 16:43:20 Re: Ordering Results by a Supplied Order