Table of Contents
How to change default timezone in MySQL?
The timezone on SiteGround’s servers is CST. This is a global setting which cannot be changed.
1) Modify the MySQL NOW() function.
2) Selecting the current date/time:
SELECT NOW();
If you want to add 2 hours to the result,
3) Use the following syntax:
SELECT DATE_ADD(NOW(), INTERVAL 2 HOUR);
if you want to subtract 2 hours from the server timezone,
4) 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.
