db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From AliasTech <jibrail.id...@gmail.com>
Subject DATE Function is not working properly
Date Wed, 10 Jun 2009 12:12:25 GMT

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.

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.

View raw message