Re: pg_query_params() problem with date_trunc() (possibly other functions as well) - Mailing list pgsql-general

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)

or if that doesn't work, try this:

... date_trunc('day', now()), date_trunc('day', $1::timestamp)

The syntax TIMESTAMP '...' is only for plain literal constants.

            regards, tom lane