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