macromedia.coldfusion.database_access
[Top] [All Lists]

Date Time Stamping issue

Subject: Date Time Stamping issue
From: "WAK123" <webforumsuser@xxxxxxxxxxxxxx>
Date: Thu, 21 Feb 2008 00:53:56 +0000 (UTC)
Newsgroups: macromedia.coldfusion.database_access

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. It appears that the later is using JDBC driver.



<Prev in Thread] Current Thread [Next in Thread>