Hi,

I think this should solve ur problem

SELECT to_date('16-JUL-2003 13:30:00','DD-MON-YYYY HH24:MI:SS') FROM DUAL

HTH

Srini