Postgres Pro
Downloads
Home   >   mailing lists

Re: How to get the previous date? - Mailing list pgsql-sql

From ramasubramanian
Subject Re: How to get the previous date?
Date
Msg-id EDF486306AE641B6975C838EB90DA7AC@ramasubramanian
Whole thread Raw
In response to How to get the previous date?  (Shruthi A <shruthi.iisc@gmail.com>)
List pgsql-sql
Tree view
Helo Madam,
    Here is the query.
select now()+ interval '-1  day '
Regards,
ram
----- Original Message -----
From: Shruthi A
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

pgsql-sql by date:

Previous
From: Dmitriy Igrishin
Date:
Subject: Re: How to get the previous date?
Next
From: "Oliveiros C,"
Date:
Subject: How to order varchar data by word