db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dmitri Pissarenko" <dmitri.pissare...@gmail.com>
Subject Re: Difference between two timestamp fields
Date Tue, 05 Jun 2007 07:51:54 GMT
Hello!

I found the error. This query is correct (SQL_TSI_SECOND instead of
SQL_TSI_FRAC_SECOND):

> > > SELECT APP.MyTable.startTime, {fn TIMESTAMPDIFF(SQL_TSI_SECOND,
> > > APP.MyTable.startTime, APP.MyTable.endTime)}
> > > FROM APP.MyTable
> > > WHERE APP.MyTable.startTime IS NOT NULL

Thanks again.

Dmitri Pissarenko
-- 
http://www.xing.com/profile/Dmitri_Pissarenko
http://dapissarenko.blogspot.com/

Mime
View raw message