db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lance J. Andersen" <Lance.Ander...@Sun.COM>
Subject Re: fn timestampdiff gives error...
Date Mon, 28 Nov 2005 20:58:27 GMT
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


Mime
View raw message