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
|