Question
CF8, Mysql, Date and Time 1 hour behin
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
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
AdChoices