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
