Re: INTERVAL parameter in PreparedStatement worked in

From: "Matt Magoffin" <postgresql(dot)org(at)msqr(dot)us>
To: "Oliver Jowett" <oliver(at)opencloud(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: INTERVAL parameter in PreparedStatement worked in
Date: 2005-10-28 00:36:42
Message-ID: 50488.219.89.94.58.1130459802.squirrel@msqr.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Aydın Toprak 2005-10-28 10:18:09 Problems with ResultSet
Previous Message Oliver Jowett 2005-10-28 00:29:21 Re: INTERVAL parameter in PreparedStatement worked in 7.4