Re: How to get the previous date?

Поиск
Список
Период
Сортировка
От ramasubramanian
Тема Re: How to get the previous date?
Дата
Msg-id EDF486306AE641B6975C838EB90DA7AC@ramasubramanian
обсуждение исходный текст
Ответ на How to get the previous date?  (Shruthi A <shruthi.iisc@gmail.com>)
Список pgsql-sql
Дерево обсуждения
Helo Madam,
    Here is the query.
select now()+ interval '-1  day '
Regards,
ram
----- Original Message -----
From: Shruthi A
Sent: Wednesday, October 14, 2009 3:10 PM
Subject: [SQL] How to get the previous date?

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 по дате отправления:

Предыдущее
От: Dmitriy Igrishin
Дата:
Сообщение: Re: How to get the previous date?
Следующее
От: "Oliveiros C,"
Дата:
Сообщение: How to order varchar data by word