[OT] Duration between two timestamps

From: phil campaigne <pcampaigne(at)charter(dot)net>
To: scrawford(at)pinpointresearch(dot)com, tomcat-user(at)jakarta(dot)apache(dot)org, pgsql-general(at)postgresql(dot)org
Subject: [OT] Duration between two timestamps
Date: 2005-02-23 02:54:28
Message-ID: 421BF064.5050108@charter.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Smith 2005-02-23 03:25:09 Re: [OT] Duration between two timestamps
Previous Message mailinglists 2005-02-23 02:45:35 Re: Triggers, again.. ;-)