justravis Posted August 22, 2007 Share Posted August 22, 2007 Is there someplace in phpmyadmin or somewhere else I can change mysql's timezone? Server version: 4.1.22-standard THANKS!!! Quote Link to comment https://forums.phpfreaks.com/topic/66108-mysql-change-db-time-to-coincide-with-local-time-zone/ Share on other sites More sharing options...
Illusion Posted August 22, 2007 Share Posted August 22, 2007 >mysqladmin --timezone=<zone name>; Quote Link to comment https://forums.phpfreaks.com/topic/66108-mysql-change-db-time-to-coincide-with-local-time-zone/#findComment-330745 Share on other sites More sharing options...
vijayfreaks Posted August 22, 2007 Share Posted August 22, 2007 Hi.. refer this link.. http://www.modwest.com/help/kb6-256.html http://www.modwest.com/help/kb5-258.html suppose this will help you.. Regards, Vijay Quote Link to comment https://forums.phpfreaks.com/topic/66108-mysql-change-db-time-to-coincide-with-local-time-zone/#findComment-330794 Share on other sites More sharing options...
justravis Posted August 24, 2007 Author Share Posted August 24, 2007 does everybody insert php formatted timestamps manually instead of using mysql timestamps? THANKS! Quote Link to comment https://forums.phpfreaks.com/topic/66108-mysql-change-db-time-to-coincide-with-local-time-zone/#findComment-332689 Share on other sites More sharing options...
fenway Posted August 27, 2007 Share Posted August 27, 2007 Why would you insert non-mysql into mysql? Quote Link to comment https://forums.phpfreaks.com/topic/66108-mysql-change-db-time-to-coincide-with-local-time-zone/#findComment-335207 Share on other sites More sharing options...
justravis Posted August 27, 2007 Author Share Posted August 27, 2007 well when i first read the above links, I thot mysql's timezone was server dependent, but if i can expect mysql's timezone to be the same regardless of hosting provider, i can always retrieve the timestamp in my desired timezone. Quote Link to comment https://forums.phpfreaks.com/topic/66108-mysql-change-db-time-to-coincide-with-local-time-zone/#findComment-335288 Share on other sites More sharing options...
fenway Posted August 27, 2007 Share Posted August 27, 2007 Assuming you set the timezone appropriately, the DB will handle this for you. Quote Link to comment https://forums.phpfreaks.com/topic/66108-mysql-change-db-time-to-coincide-with-local-time-zone/#findComment-335322 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.