db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jean T. Anderson" <...@bristowhill.com>
Subject Ref Guide: max number val for 'DATE' gets error 22008
Date Thu, 31 Aug 2006 17:56:16 GMT
I'm checking docs for the builtin funcs in the Reference Guide and
spotted a problem with DATE:

http://db.apache.org/derby/docs/dev/ref/rrefdatefunc.html

The description says "The argument must be a date, timestamp, a positive
number less than or equal to 3,652,059" so I tried this:

ij> values date (3652059);
ERROR 22008: '3652059' is an invalid argument to the date function.

Does anybody know any history (or lore) behind that 3,652,059 value?

It looks like the highest is 2,932,897 (Dec 31, 9999):

ij> values date (2932897);
1
----------
9999-12-31

1 row selected
ij> values date (2932898);
ERROR 22008: '2932898' is an invalid argument to the date function.

Unless somebody knows otherwise, I'll add a note to the wiki that the
max value should be changed from 3,652,059 to 2,932,897.

thanks,

-jean

Mime
View raw message