Portada del sitio > Sistemas > Administración > WWW > mysql > Modificar timezone mysql
Modificar timezone mysql
Miércoles 13 de agosto de 2014, por
# mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql -p
# mysql -u root -p
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2014-08-13 03:55:10 |
+---------------------+
1 row in set (0.00 sec)
mysql> SET time_zone='Europe/Madrid';
Query OK, 0 rows affected (0.02 sec)
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2014-08-12 23:55:25 |
+---------------------+
1 row in set (0.00 sec)