Re: fn timestampdiff gives error...

[Lance J. Andersen]

Myrna, Try having the timestamp values closer together and give it a go. -lance Myrna van Lunteren wrote: 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