db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jose de Castro <jose.decas...@voxeo.com>
Subject Timestamp Arithmetic
Date Tue, 14 Nov 2006 17:49:37 GMT
I trying to calculate the duration (in seconds) between two timestamps. 
Historically, I have either used a non-standard function such as 
DateDiff in SQL Server and MySQL or performed a direct arithmetic 
calculation (i.e. timestamp1-timestamp2) in PostgreSQL.

I have searched the reference documentation and tried both of the 
aforementioned solutions with no success. I am running the latest stable 
Derby build (10.2) on  a Windows XP box.

What is the correct way of doing this in Derby?

Thanks in advance,

Jose de Castro
Senior Software Engineer
Voxeo Corporation

View raw message