to_date problems

[slimdave]

alternatively you can ...

alter session set nls_date_format='dd Mon YYYY HH24:MI:SS';

... which will change your session default date format.