Hi Joel, select to_date('01-JAN-01','FXDD/MM/YYYY') from dual; Thanks a million. That's exactly what I need. I wasn't aware of the FX modifier. And thanks Norman too! Regards, Fergal -- //www.freelists.org/webpage/oracle-l