in reply to Perl DBI Loss of Date Precision

maybe you want to set the environment:
export NLS_DATE_FORMAT='yyyymmdd hh24:mi:ss'
the same for the apache webserver:
PerlSetEnv NLS_DATE_FORMAT 'yyyymmdd hh24:mi:ss'