CF8 not interpreting time in an Oracle date

forums_noreply@adobe.com — Wed, 15 Jul 2009 19:30:00 GMT

In testing for my co's migration from CF6 to CF8, found an odd behavior in CF8. The Data coming from the Oracle (9) table, which is of datatype Date, is 7/13/2009 3:31:30 PM. I'm outputting this value as #dateFormat(qry.date, 'mm/dd/yy')# #timeFormat(qry.date, 'hh:mm tt')#. In CF6 it correctly outputs the time as 3:31 pm, but in CF8 it outputs the time as 12:00 am.

Doing a straight output of #qry.date# in CF8 outputs {ts '2009-07-13 00:00:00'}, which suggests that CF8 simply isn't recognizing the time component of the Date datatype. Is there a known issue with CF8 and Oracle 9? or could this be a driver issue?

Thanks,

Christophe

Adobe Community : All Content - All Communities

CF8 not interpreting time in an Oracle date