Simplicity in time/date functions

Поиск
Список
Период
Сортировка
От Ben-Nes Michael
Тема Simplicity in time/date functions
Дата
Msg-id 03dc01c1948b$4e299ec0$aa0f5ac2@canaan.co.il
обсуждение
Ответы Re: Simplicity in time/date functions
Re: Simplicity in time/date functions
Re: Simplicity in time/date functions
Список pgsql-general
Hi All

I was amazed that:
select current_date() - 28 dont work at postgresql :(

I checked here and there and found that in postgresql i need to do something
like this:

select current_date::TIMESTAMP - '28 days'::INTERVAL as date

whow, is there a shorter way ?

--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
http://sites.canaan.co.il
--------------------------



В списке pgsql-general по дате отправления: