Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist

Поиск
Список
Период
Сортировка
От Nico Grubert
Тема Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist
Дата
Msg-id 49B0C9E0.5050505@gmail.com
обсуждение исходный текст
Ответ на Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist  ("Adam Rich" <adam.r@sbcglobal.net>)
Список pgsql-general
Дерево обсуждения 
> OK, so you want to see if a timestamp is greater than now()?  Why not
> just compare them?
>
> where a.from_datetime >= now()

No, not the whole timestamp. I dont want to check the time.
So I had to truncate the datetime with:

date_trunc('day', a.from_datetime) >= date_trunc('day', NOW())

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist