Re: INTERVAL parameter in PreparedStatement worked in 7.4 - Mailing list pgsql-jdbc

Matt Magoffin wrote:

> I used to use the following style statement with the 7.4 series JDBC driver:
>
> select * from users users where users.createdDate < (CURRENT_DATE -
> INTERVAL ?)
>
> and would set the parameter to a string value of "14 DAYS"
>
> but in the Postgres 8 driver, this query executes but does not seem to
> ever return anything. Is there a better syntax I could use to make this
> work?

"CAST (? AS INTERVAL)" should work.

Or use org.postgresql.util.PGInterval:

   stmt.setObject(1, new PGInterval("14 days"));

-O