How to change the MySQL timezoneAA-00339When you develop your website, you may have to compare a certain date/time with the current date/time on the server. The timezone on our servers is EST. This is a global setting which cannot be changed. You can, however, use an easy workaround if you wish to use a different timezone – you can modify the return of the MySQL NOW() function. Let’s take a look at the most standard query for selecting the current date/time: SELECT NOW(); If you want to add 2 hours to the result, you can use the following syntax: SELECT DATE_ADD(NOW(), INTERVAL 2 HOUR); In a similar way, if you want to subtract 2 hours from the server timezone, you can use this query: SELECT DATE_SUB(NOW(), INTERVAL 2 HOUR); Using DATE_SUB and DATE_ADD, you can modify the query result to fit your specific needs. |