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

From Matt Magoffin
Subject Re: INTERVAL parameter in PreparedStatement worked in
Date
Msg-id 50488.219.89.94.58.1130459802.squirrel@msqr.us
Whole thread Raw
In response to Re: INTERVAL parameter in PreparedStatement worked in 7.4  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
Thank you, the CAST worked perfectly.

-- m@

> "CAST (? AS INTERVAL)" should work.
>
> Or use org.postgresql.util.PGInterval:
>
>    stmt.setObject(1, new PGInterval("14 days"));
>
> -O


pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: INTERVAL parameter in PreparedStatement worked in 7.4
Next
From: Aydın Toprak
Date:
Subject: Problems with ResultSet