Monday, 16 July 2012

ORA-01843: not a valid month

ORA-01843 not a valid month
 
Cause: A date specified an invalid month. Valid months are: January-December, for format code MONTH, and Jan-Dec, for format code MON.
 
Action: Enter a valid month value in the correct format


Example : 

How :-> 
  * FROM emp
SELECT
 WHERE

Error : ORA-01843: not a valid month


Solution :

SELECT * FROM emp
 WHERE


Try it !!

 

BIRTH_DT >= '31/DEC/1988' AND BIRTH_DT <= '31/DEC/2012'
BIRTH_DT >= '31/12/1988' AND BIRTH_DT <= '31/12/2012'

No comments:

Post a Comment