php - MySQL now() change timezone - Stack Overflow

After you open the connection to MySQL, run the following as a query: SET time_zone = timezone; Then all functions you do will run for that timezone for that connection (i.e. until you close the "link" to the database". If you have the appropriate permiss

stackoverflow.com