fenway Posted March 8, 2007 Share Posted March 8, 2007 Sheeri has a short & sweet article on this timely (pun intended) matter. Robin has one too. Quote Link to comment https://forums.phpfreaks.com/topic/41770-daylight-saving-time-2007-changes-mysql/ Share on other sites More sharing options...
arianhojat Posted April 25, 2007 Share Posted April 25, 2007 hmmm some of my times in a table were 1 hr early on 'manual entered' times. so users picks 5pm in an app, and it shows up as 4pm. i assumed the Dateinserted field would be definately off by 1hr since it used system time. But i didnt know why the manual entered time by the user was 1 hr off. Newly inserted entries seem to be okay now (i think). I tried above posted articles to make sure its fixed but i am not sure now the time is okay on server... Running: SELECT @@global.time_zone, @@session.time_zone, UNIX_TIMESTAMP('2007-03-11 02:00:00'), UNIX_TIMESTAMP('2007-03-11 03:00:00'); Results in: 'SYSTEM', 'SYSTEM', 1173596400, 1173600000 the last 2 times the articles say should be the same. it is using SYSTEM time on win2000 IIS server with php/MYSQL4.12. the daylight savings patch was applied, and time corrected, yet those 2 UNIX_TIMESTAMPS are off. Anyone know how I can make them the same? Quote Link to comment https://forums.phpfreaks.com/topic/41770-daylight-saving-time-2007-changes-mysql/#findComment-238343 Share on other sites More sharing options...
arianhojat Posted April 27, 2007 Share Posted April 27, 2007 anyone? Quote Link to comment https://forums.phpfreaks.com/topic/41770-daylight-saving-time-2007-changes-mysql/#findComment-239782 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.