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:34:26 GMT
Hello!

> > SELECT APP.MyTable.startTime, {fn TIMESTAMPDIFF(SQL_TSI_FRAC_SECOND,
> > APP.MyTable.startTime, APP.MyTable.endTime)}
> > FROM APP.MyTable
> > WHERE APP.MyTable IS NOT NULL
> Should this be
> WHERE APP.MyTable.startTime IS NOT NULL
> ?

Thanks for the hint!

Now I'm getting this exception:

SQL State = 22003 SQL Code = 30000 SQL Message = The resulting value
is outside the range for the data type INTEGER. Exception message =
java.sql.SQLDataException: The resulting value is outside the range
for the data type INTEGER.

> What version are you using?

I'm using the version, which is delivered together with Java.

java -version produces this output:

java version "1.6.0"
Java(TM) SE Runtime Environment (build 1.6.0-b105)
Java HotSpot(TM) Client VM (build 1.6.0-b105, mixed mode, sharing)

Best regards

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

Mime
View raw message