DATE Function is not working properly

Hi there,

I just started on Derby. The date funtion does not seem to be functioning correctly. For example,

ij> select col1, date('09/30/2009') from table1;
COL1       |2
----------------------
9          |2009-09-30

as compared to
ij> select col1, date('09/31/2009') from table1;
ERROR 22008: '09/31/2009' is an invalid argument to the date function.

Notice  that 09/30/2009 and 09/31/2009 are valid dates and yet Derby flags 09/31/2009 as an invalid date.

Please advise.

Thanks.