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.
--
View this message in context:
http://www.nabble.com/DATE-Function-is-not-working-properly-tp23960955p23960955.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
