db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Myrna van Lunteren <m.v.lunte...@gmail.com>
Subject fn timestampdiff gives error...
Date Fri, 25 Nov 2005 16:08:05 GMT
Hi,

Is this a bug? It seems to me it is...

In ij:
ij> create table tab1(TMSTCOL1 TIMESTAMP, TMSTCOL2 TIMESTAMP);
0 rows inserted/updated/deleted
ij> INSERT INTO tab1 VALUES ({ts '1994-06-12 11:20:10'},{ts '1996-05-10
10:07:05'});
1 row inserted/updated/deleted
ij> SELECT {FN TIMESTAMPDIFF(SQL_TSI_FRAC_SECOND,TMSTCOL1,TMSTCOL2)} FROM
tab1;
1
-----------
ERROR 22003: The resulting value is outside the range for the data type
INTEGER.

Thx,
Myrna

Mime
View raw message