date function not recognized :(

[SANJAY_G]

Hi Friends,

I am doing this simple select command against my table EMP...

select count(*) from EMP where
to_date(birthdate,'mmddyyyy')>='01-JAN-90';

to_date(birthdate,'mmddyyyy')>='01-JAN-90'
*
ERROR at line 2:
ORA-01843: not a valid month

The date format you are giving doesn't match with the literal value.
Use either

to_date(birthdate,'mmddyyyy')>='01011990'

or

to_date(birthdate,'DD-MON-YY')>='01-JAN-90'

HTH