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 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 - 14:11:13 CST