Skip to content

Tag Archives: timezone

How to change mysql time zone

07-Nov-09

How to change mysql time zone Edit /etc/my.cnf and change your time zone. root@box1 [/var/lib/mysql]# cat /etc/my.cnf [mysqld_safe] timezone = Europe/London ~ [mysqld] set-variable = max_connections=500 safe-show-database Login to mysql and check the time now. root@box1 [/var/lib/mysql]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 369 [...]

Filed in LAMP | Also tagged | Comments (0) »

How to change the time zone within a php script

06-Nov-09

How to change the time zone within a php script You can change the time zone within a php script. Here is a sample code: You can set the timezone in .htaccess as well. Add the line: SetEnv TZ America/Indianapolis List of timezones is here: http://us.php.net/manual/en/timezones.php

Filed in php | Also tagged | Comments (0) »