DATE Function is not working properly

[AliasTech]

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.

[Bernt M. Johnsen]

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

[AliasTech]

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