Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist - Mailing list pgsql-general

Scott Marlowe <scott.marlowe@gmail.com> writes:
> The functionality is the same, since the now() will get rounded down
> to the date with time of 00:00:00.  So, anytime for that day will be
>> = to the output of date_trunc('day',now())

Yeah.  So actually it's sufficient to do
    a.from_datetime >= current_date
and a regular index on from_datetime would be fine for that.

            regards, tom lane