are u sure dear

the format is correct because if I test it this way...

select to_date('01012007','mmddyyyy') from dual;

to_date('
---------
01-JAN-07

and my birthdate column is varchar2(8) and not a date column