Request a Demo
Home   >   mailing lists

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

From Dmitriy Igrishin
Subject Re: How to get the previous date?
Date
Msg-id b4399d110910140243q408a3e50y46dd7da936bdfe57@mail.gmail.com
Whole thread Raw
In response to How to get the previous date?  (Shruthi A <shruthi.iisc@gmail.com>)
List pgsql-sql
Tree view
Hello.

current_date - 1 is the solution.

2009/10/14 Shruthi A <shruthi.iisc@gmail.com>
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: Shruthi A
Date:
Subject: How to get the previous date?
Next
From: "ramasubramanian"
Date:
Subject: Re: How to get the previous date?