Re: Simple question!

Jerra wrote
> Is there a date format which Oracle understands no matter what date format
> has been set as standard?

No. Simply solution: ALWAYS explicitly supply the format in a to_date:

    select to_date( '01-JAN-1900', 'DD-MON-YYYY')     from dual;

Arjan. Received on Thu May 20 1999 - 11:07:28 CDT