Re: How to get the previous date?

From: Dmitriy Igrishin <dmitigr(at)gmail(dot)com>
To: Shruthi A <shruthi(dot)iisc(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to get the previous date?
Date: 2009-10-14 09:43:51
Message-ID: b4399d110910140243q408a3e50y46dd7da936bdfe57@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello.

current_date - 1 is the solution.

2009/10/14 Shruthi A <shruthi(dot)iisc(at)gmail(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message ramasubramanian 2009-10-14 10:00:52 Re: How to get the previous date?
Previous Message Shruthi A 2009-10-14 09:40:40 How to get the previous date?