Re: CF8. ODBC Vs JDBC Oracle Date. Time portion not returned

["WAK123" <webforumsuser@xxxxxxxxxxxxxx>]

I am facing a similiar issue in a different context. When I use select xyz_Date 
from abc table in coldfusion cfquery tag, the out put comes as follows:

 CF5 - '05-MON-2007'

 CF8 - '2008-01-27 00:00:00.0'

 Note: The xyz_Date is stored without time stamp in the database.

 both running on 10.2.0.3 Oracle version. This is creating problem when 
inserting dates when we only use xyz_date as a value to be inserted. It worked 
fine on CF5 but not on CF8 due to format change. Is there a way to set it to 
behave like CF5.