arianhojat Posted May 1, 2007 Share Posted May 1, 2007 Once you enter a Timestamp, can it change depending on something on your server? Ive had times shift 1 hour up and down, and user seems to not be at fault. The change is not immediate, it occurs after correct meeting time is inserted. The correct system time is set on win2000 server (which since its old, has no DaylightSavingsTime patch from Microsoft ), Although the user manully inserts this time, so its not dependant on system time at all. I might run Intellimon's free win2000 DST patch n4xt week to see if helps, but again should make no difference on manually inserting times into database. Quote Link to comment https://forums.phpfreaks.com/topic/49522-mysql-timestamp-values-shifting-after-inserted-into-db/ Share on other sites More sharing options...
trecool999 Posted May 1, 2007 Share Posted May 1, 2007 ??? Quote Link to comment https://forums.phpfreaks.com/topic/49522-mysql-timestamp-values-shifting-after-inserted-into-db/#findComment-242738 Share on other sites More sharing options...
Wildbug Posted May 1, 2007 Share Posted May 1, 2007 The first TIMESTAMP column in a table is reset to NOW() when UPDATE'ing that row... at least it used to be the default, and I think it still is. So, the TIMESTAMP can change although you don't explicitly set it in that case. Quote Link to comment https://forums.phpfreaks.com/topic/49522-mysql-timestamp-values-shifting-after-inserted-into-db/#findComment-242778 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.