Coldfusion upgrade, dates not being read properly

Hi guys,

We upgraded our server from Coldfusion 8 to 10 not too long ago and there were problems initially but most of them got fixed. Now the issue is that  dates are not getting retrieved properly when, prior to the upgrade, it was.

Let's say that on the database for a particular person, it shows the date as 8:34 AM but when you try to display the date, it only shows up as 00:00 AM (or 12:00 AM depending on how we changed the format in the output). The strange thing is that the information is getting passed TO the database properly (Oracle 11g), its just not retrieving it right and what's stranger is that the days, months, and year is getting retrieved ok, just not the seconds, minutes and hours.

I've tested using different types of functions for the output (timeformat, datetimeformat), used -Doracle.jdbc.J2EE13Compliant=true and -Doracle.jdbc.V8Compatibile=true, updated our ojdbc14.jar to ojdbc6.jar (since our JDK was 1.6), and tried various other solutions that were on the web and on the discussion but they all haven't worked so far. Even when I cfdump the query, it gives me {ts 'xxxx-xx-xx 00:00:00'} for every entry.

Any help or direction would be very appreciated