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!

TO_DATE Not a Valid Month

Arif KhadasJan 19 2011 — edited Jan 19 2011

Hi Guys,

I have a problem.

SELECT  TO_DATE ('01-APR-00', 'DD-MON-RR') FROM DUAL
*
Error at line 0
ORA-01843: not a valid month

Can anyone please explain me the reason for above error.

SQL*Plus: Release 8.0.6.0.0 - Production on ÇáÃÑÈÚÇÁ 01 19 10:46:16 201

(c) Copyright 1999 Oracle Corporation. All rights reserved.

ãÊÕá È:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production

Best Regards

Arif Khadas

This post has been answered by Hoek on Jan 19 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 16 2011

Added on Jan 19 2011

8 comments

13,317 views