Also you should specify 4 digits for the year, much safer.
Jim
"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 Fri Apr 05 2002 - 00:19:24 CST
