Different drivers maybe? Does it matter? What does DateFormat and the other CF date functions give for them both? I'd guess (a bid guess too) that CF treats them both the same.
Adrian Building a DB of errors at cferror.org -----Original Message----- From: Alex DeMarco [mailto:[EMAIL PROTECTED] Sent: 06 October 2008 23:32 To: cf-talk Subject: 10gRac database returning odd time When using a regular 10g (non tac) database the query returns this: 2005-06-23 13:18:27.0 However, under 10gRac (using the most current jdbc driver) returns this {ts '2005-06-23 00:00:00'} for the same data. Anyone know why? - Alex ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313494 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
