Re: [SQL] How to get the previous date?

[ramasubramanian]

Helo Madam,
    Here is the query.
select now()+ interval '-1  day '
Regards,
ram
  ----- Original Message ----- 
  From: Shruthi A 
  To: pgsql-sql@postgresql.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