SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Date value Error ORA-01821: date format not recognized

873006Aug 17 2012 — edited Aug 17 2012

Hi Team,

will executing the below query i am getting ORA-01821: date format not recognized

SELECT DISTINCT  to_date(TO_CHAR(csactivated,'DDMONRR'||'24:00:00'),'DD-MON-RR hh24:mi:ss') FROM CUSTOMER_ALL

and I am using 10g version and i have checked the NLS_SESSION_PARAMETERS.NLS_TIMESTAMP_FORMAT i.e(DD-MON-RR HH.MI.SSXFF AM)

This post has been answered by Manik on Aug 17 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 14 2012

Added on Aug 17 2012

23 comments

34,443 views