Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01810: format code appears twice (oracle10g,linux)
ORA-01810: format code appears twice [message #301329] Wed, 20 February 2008 01:30 Go to next message
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?
Re: ORA-01810: format code appears twice [message #301331 is a reply to message #301329] Wed, 20 February 2008 01:33 Go to previous messageGo to next message
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
Senior Member
The format for minute is mi not mm
Re: ORA-01810: format code appears twice [message #301332 is a reply to message #301329] Wed, 20 February 2008 01:34 Go to previous message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
MM appears twice.
Minute is MI.

Regards
Michel
Previous Topic: about dates
Next Topic: sql query beteem two times (merged)
Goto Forum:
  


Current Time: Tue Nov 05 13:52:51 CST 2024