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
