Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: to_date - "formated code appear twice" error
I verified on the 9i. It's right.
"ZV" <valliz_at_consultant.com> wrote in message
news:3CACB361.30A79C2E_at_consultant.com...
> I think it is your "mm" (check where the "*" appears in the error
> message).
>
> It is "mm" for the month, but "mi" for the minutes...
>
> ZV
>
> Zhiliang Hu wrote:
> >
> > I got a weired problem:
> >
> > ____________________________________________________
> > SQL> update namelist set timearri=to_date('02-27-02 08:15:00', 'mm-dd-yy
> > hh:mm:ss am') where nameid='4841';
> >
> > update namelist set timearri=to_date('02-27-02 08:15:00', 'mm-dd-yy
> > hh:mm:ss am') where nameid='4841'
> > *
> > ERROR at line 1:
> > ORA-01810: format code appears twice
> > -------------------------------------------------------------------
> >
> > Any hint? (where is "appears twice"? ;-)
> >
> > Thanks!
> > Zhiliang
Received on Thu Apr 04 2002 - 21:36:43 CST