Helo Madam,
Here is the query.
select now()+ interval '-1 day '
Regards,
ram
----- Original Message -----
From: Shruthi A
To: pgsql-sql(at)postgresql(dot)org
Sent: Wednesday, October 14, 2009 3:10 PM
Subject: [SQL] How to get the previous date?
Hi,
I'm using Enterprise DB PostgresPlus version 8.3.
Is there is a simple function or command like previous_date(mydate) which when passed a particular date, simply returns the previous date? I tried
mydate - 1
but this doesnt work.
Thanks,
Shruthi