Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist
От
Adam Rich
Тема
Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist
Дата
Msg-id
011401c99e29$d8bd4460$8a37cd20$@r@sbcglobal.net
Ответ на
Список
Дерево обсуждения
After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not
exist Nico Grubert <nicogrubert@gmail.com>
Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist Tom Lane <tgl@sss.pgh.pa.us>
Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp
does not exist Nico Grubert <nicogrubert@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>
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 Nico Grubert <nicogrubert@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 Nico Grubert <nicogrubert@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>
Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp
does not exist Nico Grubert <nicogrubert@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 Tom Lane <tgl@sss.pgh.pa.us>
>
>
> > 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())
>
If you're going to truncate the NOW(), just go with CURRENT_DATE instead.
В списке pgsql-general по дате отправления
От: Scott Marlowe
Дата:
От: Nico Grubert
Дата: