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

От

Nico Grubert

Тема

Дата

6 марта 2009 г. в 02:58:21

Msg-id

49B0C988.7050003@gmail.com

обсуждение

Ответ на

Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist (Tom Lane)

Список

pgsql-general

Дерево обсуждения

After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist Nico Grubert <nicogrubert@gmail.com> 5 марта 2009 г. в 14:13:59

Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist Tom Lane <tgl@sss.pgh.pa.us> 5 марта 2009 г. в 14:42:35

Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist Nico Grubert <nicogrubert@gmail.com> 6 марта 2009 г. в 02:53:32

Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist "Adam Rich" <adam.r@sbcglobal.net> 6 марта 2009 г. в 03:02:04

Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist Scott Marlowe <scott.marlowe@gmail.com> 6 марта 2009 г. в 02:57:27

Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist Scott Marlowe <scott.marlowe@gmail.com> 6 марта 2009 г. в 02:59:14

Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist Nico Grubert <nicogrubert@gmail.com> 6 марта 2009 г. в 02:58:21

Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist Scott Marlowe <scott.marlowe@gmail.com> 6 марта 2009 г. в 03:01:40

Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist Scott Marlowe <scott.marlowe@gmail.com> 5 марта 2009 г. в 14:50:41

Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist Nico Grubert <nicogrubert@gmail.com> 6 марта 2009 г. в 02:59:50

Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist "Adam Rich" <adam.r@sbcglobal.net> 6 марта 2009 г. в 03:03:23

Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist Nico Grubert <nicogrubert@gmail.com> 6 марта 2009 г. в 03:35:38

Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist Scott Marlowe <scott.marlowe@gmail.com> 6 марта 2009 г. в 03:02:49

Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist Tom Lane <tgl@sss.pgh.pa.us> 6 марта 2009 г. в 12:04:55


> This query makes little sense.  Why are you trying to convert a
> timestamp to a timestamp?  Is this a bizarre substitute for date_trunc()?

Got it:
Thanks for the "date_trunc" tip.

This query works fine:
date_trunc('day', a.from_datetime) >= date_trunc('day', NOW())

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

Предыдущее

От: Scott Marlowe

Дата: 6 марта 2009 г. в 02:57:27

Сообщение: Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist

Следующее

От: Scott Marlowe

Дата: 6 марта 2009 г. в 02:59:14

Сообщение: Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist