Re: [GENERAL] [OT] Duration between two timestamps

2005-02-22 Thread Chris Smith
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 re

[GENERAL] [OT] Duration between two timestamps

2005-02-22 Thread phil campaigne
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