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.