db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen" <Bernt.John...@Sun.COM>
Subject Re: DATE Function is not working properly
Date Wed, 10 Jun 2009 12:35:44 GMT
>>>>>>>>>>>> AliasTech wrote (2009-06-10 05:12:25):
> 
> 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.

AFAIK there are 30 days in September, and thus the error message is
correct.


> 
> 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.
> 

-- 
Bernt Marius Johnsen, Staff Engineer
Database Technology Group, Sun Microsystems, Trondheim, Norway

Mime
View raw message