db-derby-user mailing list archives

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



Bernt M. Johnsen wrote:
> 
>>>>>>>>>>>>> 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
> 
>  
> 

Hey Bernt,

I'm sorry. It's my stupid mistake. Thanks for your prompt reply. I feel like
an idiot.

Regards
-- 
View this message in context: http://www.nabble.com/DATE-Function-is-not-working-properly-tp23960955p23965788.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message