Re: Odd math

From: Kathinka Diehl <kathinka_at_rrr.de>
Date: 2000/07/13
Message-ID: <8kjmlk$2mo6a$1@ID-6887.news.cis.dfn.de>#1/1

Connor McDonald <connor_mcdonald_at_yahoo.com> schrieb:
> select
> to_date('01JAN2000','ddmmyyyy')
> to_date('01JAN2000','dd/mm/yyyy'),
> to_date('01JAN2000','dd-mon-yyyy')
> from dual
>
> all work .... Hmmmmmmm

I don't understand.

SQLWKS> select
     2> to_date('01JAN2000','ddmmyyyy')
     3> from dual

TO_DATE('01JAN2000',

---

ORA-01858: a non-numeric character was found where a numeric was expected

But that seems ok to me. If I try ('01JAN2000','ddmonyyyy') or ('01012000','ddmmyyyy') it works fine.

Regards,
Kathinka Received on Thu Jul 13 2000 - 00:00:00 CDT