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. 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? 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? 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
Archived
This topic is now archived and is closed to further replies.