OraFAQ Forum: SQL & PL/SQL » ORA-01810: format code appears twice

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01810: format code appears twice (oracle10g,linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01810: format code appears twice [message #301329]

Wed, 20 February 2008 01:30

sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai

Senior Member

hi,
i have execute this query i got ORA-01810: format code appears twice error

scripts:

SELECT *
FROM demployees
WHERE last_updated_timestamp =TO_DATE('2/20/2008 12:33:01 ', 'mm/dd/yyyy hh:mm ss')

Why it's comes?

Report message to a moderator

Re: ORA-01810: format code appears twice [message #301331 is a reply to message #301329]

Wed, 20 February 2008 01:33

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

The format for minute is mi not mm

Report message to a moderator

Re: ORA-01810: format code appears twice [message #301332 is a reply to message #301329]

Wed, 20 February 2008 01:34

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

MM appears twice.
Minute is MI.

Regards
Michel

Report message to a moderator

Previous Topic:	about dates
Next Topic:	sql query beteem two times (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 20 14:33:11 CDT 2025