CF8, Mysql, Date and Time 1 hour behin

Report · Mar 22, 2008

Hi Guys we have CF8, and we are using Mysql 5.0 the connection with the database is perfect
but we have a very estrange problem we store date and time information into the database
when we query the database we get the right information however when the coldfusion script
show the result in the web the information is 1 day behind, I've been looking around in the CF8 administration to see if I can change some settings without any success.

Example:

eventID eventType eventVenue eventDetail eventStart eventstartTime eventEnd eventendTime eventLevel eventActive eventTS
2 5 1 spec shares @ college 2008-03-19 14:00:00 2008-03-19 16:00:00 1 yes 2008-03-12 17:00:26
3 2 1 intro @ college 2008-03-20 10:00:00 2008-03-19 16:00:00 1 yes 2008-03-12 17:22:59
--------------------------
of interest are the time and date columns eventStart, eventstartTime, eventEnd, eventendTime - please note the values
--------------------------
retrieving that information (without modification) via coldfusion are 1 day behind for dates (actually 1 hour behind) and 1 hour and 1 minute forward for time
2 5 1 spec shares @ college Mar 18 2008 23:00 15:01 18-03-2008 17:01 1 yes

We reproduce the problem in Windows or Linux so we believe it's a problem with the coldfusion
can you give us any advise ?

Regards
Ivan

Report · Mar 24, 2008

Where is your server? Is is in a different time zone than yours?
How do you store? In which time zone?

Any daylight savings problem?

Report · Apr 04, 2008

I don't think the problem with with CF. In addition to the server's timezone, which JVM are you using? You need to at least 1.4.2_11 to account for the recent change in daylight savings time.

http://kb.adobe.com/selfservice/viewContent.do?externalId=d2ab4470