http://www.perlmonks.org?node_id=367306


in reply to DBI Date Formatting

Issue the following SQL after you connect:

alter session set nls_date_format='YYYYMMDD';

Then all dates returned will be of the format you require.