macromedia.coldfusion.database_access
[Top] [All Lists]

CF8, Mysql, Date and Time 1 hour behin

Subject: CF8, Mysql, Date and Time 1 hour behin
From: "costalivan" <webforumsuser@xxxxxxxxxxxxxx>
Date: Sun, 23 Mar 2008 06:48:55 +0000 (UTC)
Newsgroups: macromedia.coldfusion.database_access

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




<Prev in Thread] Current Thread [Next in Thread>