They are datetime fields, i guess in informix it is just called date. and the servers are actually accross the street from one another.
----- Original Message ----- From: "Jochem van Dieten" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, October 30, 2002 12:38 PM Subject: Re: Times Return Wrong > Tyler Clendenin wrote: > > > I am using Cold Fusion MX and connecting to an informix database > > through an odbc source. The problem is that all times being reutrned > > from the queries are actually three hours greater then what is in the > > database. Anyone know what this could be. I am guessing some sort of > > weird time zone compatiblity attept gone horribly wrong. > > What datatypes? TIMESTAMP WITH TIMEZONE or just TIMESTAMP? What timezone > is the server running at? > > Jochem > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
