Quick Links

How to get the previous date?

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

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

Responses

Re: How to get the previous date? at 2009-10-14 09:43:51 from Dmitriy Igrishin
Re: How to get the previous date? at 2009-10-14 10:00:52 from ramasubramanian
Re: How to get the previous date? at 2009-10-14 20:41:24 from msi77
Re: How to get the previous date? at 2009-10-17 11:41:47 from Jasen Betts

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Dmitriy Igrishin	2009-10-14 09:43:51	Re: How to get the previous date?
Previous Message	UPGRADING NOTICE TO EMAIL USERS!!!	2009-10-13 08:30:20	DEAR EMAIL USER!!!