db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@debrunners.com>
Subject Re: fn timestampdiff gives error...
Date Mon, 28 Nov 2005 23:20:23 GMT
Daniel John Debrunner wrote:


> Is this function always returning an INTEGER?
> 
> My guess is that it's up to the engine to define the range it handles,
> not ODBC or JDBC.

Though maybe I'm wrong, ODBC does say:

"Returns the integer number of intervals of type interval"

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbctime__date__and_interval_functions.asp

Thus, the example in the test would be out of range for any conforming
implementation.

Dan.



Mime
View raw message