Hey guys.... gals... Happy Easter Fertility Rights Spring Celebrations to all... as you can see I'm working :-(
A client recently updated his linux box and now I've got an issue that is puzzling me. I'm using <cfset RightNow = Now()> #RightNow# I'm getting the correct time displayed on the page Then using <cfset theDate = CreateODBCDateTime(RightNow)> I insert theDate into a postgres table field Date_Out which is timestamp with time zone and I get the correct time it seems... We are Pacific Daylight Savings time here in Los Angeles. "2012-04-08 10:57:37-07" and then later reading the Date_Out field and formatting it like this it shows up as 9:57 <td>#TimeFormat(theHistory.Date_Out,"H:mm")#</td> 9:57 is of course wrong by one hour Going through all the time and time zone settings on the linux box all seems right. Any ideas where I should go look next? Stumped for sure. Thanks for any help I can get ;-) ~Gonzo ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350661 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
