There might be a straightforward way, however the workaround will be to issue sql alter session set nls_date_format='DD/MON/YYYY'; and then your insert/update.