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 returns the previous date? I tried
> mydate - 1
> but this doesnt work.
> Thanks,
> Shruthi
Почта со встроенным плеером находится здесь: http://mail.yandex.ru/promo/new/wysiwyg