[OT] Duration between two timestamps

Hi Phil,

Have you tried copying the insert statement straight into postgres?
print it out (or log it or whatever) and try that first.. that'll narrow
things down a little.

phil campaigne wrote:

Hi All,
In my java application I need to subtract two java.sql.timestamps. and I
want to store the result as sql type "interval".
But my insert statement is failing.

Does anyone know what java type I need to use in the insert statement?
(it must accept null values)
thanks in advance,
Phil

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

--
Regards,

Chris Smith

Suite 30, 45-51 Huntley St, Alexandria, NSW 2015 Australia

Ph: +61 2 9517 2505
Fx: +61 2 9517 1915

email: info@interspire.com
web: www.interspire.com