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

Try this:

select cast(mydate as date) -1

> 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
returnsthe previous date? I tried 
 
> mydate - 1 
> but this doesnt work. 
> Thanks, 
> Shruthi 

Почта со встроенным плеером находится здесь: http://mail.yandex.ru/promo/new/wysiwyg