Modificar timezone mysql

Miércoles 13 de agosto de 2014, por Aitor Roma Vázquez

# 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)

Comentar este artículo