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/
