| 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> |
|---|---|---|
| ||
| Previous by Date: | Migrating Code from v.4.5 to v.MX6, DChew |
|---|---|
| Next by Date: | Creating ODBC socket connection to Excel, graveyardfashions |
| Previous by Thread: | Migrating Code from v.4.5 to v.MX6, DChew |
| Next by Thread: | Re: CF8, Mysql, Date and Time 1 hour behin, Oguz.Demirkapi |
| Indexes: | [Date] [Thread] [Top] [All Lists] |