Re: DB2 valid dates

I did not intend to but while playing with a function I created and tried
to use date 0300-02-29. The function did not like it but it was created
using standard date handling. Bug or something I don't know about supported
dates?

From my investigation, supported dates are from 0001-01-01 to 9999-12-31.

Should I expect the following to work? To simplify the problem, here are
the relevant date things.

SELECT date('0300-02-28')+ 1 days from sysdummy1
Date expression
0300-02-29

SELECT date('0300-02-29') from sysdummy1
DATE
++++++++++

SELECT date('0300-03-01') - 1 days from sysdummy1

Date expression
0300-02-28
Looking more and more like a bug. Other leap year (non-leap year)
calculations seem to work (although I didn't test them all). Anyone know if
this is some kind of built-in error or just a bug?

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.