Re: pg_query_params() problem with date_trunc() (possibly other functions as well)

On 5/16/14, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> patrick keshishian <pkeshish@gmail.com> writes:
>> I started to look into using pg_query_params() with some
>> php scripts, but ran into this issue where I get:
>
>> PHP message: PHP Warning: pg_query_params(): Query failed: ERROR:
>> invalid input syntax for type timestamp: "$1"
>> LINE 1: ... date_trunc('day', now()), date_trunc('day', TIMESTAMP '$1')
>
> You probably want just this:
>
> ... date_trunc('day', now()), date_trunc('day', $1::timestamp)

This worked.

Thank you for your quick response!
--patrick

>
> The syntax TIMESTAMP '...' is only for plain literal constants.
>
>             regards, tom lane
>