Change default timezone in MySQL

Change default timezone in MySQL

49
0
SHARE
Linux Reseller Hosting

How to change default timezone in MySQL?

images-5

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.

Windows Shared Hosting

Our Partner

partner-cloudflare
partner-cloudlinux
partner-cpanel-whm
partner-Paralleles-plesk-panel
partner-sitelock
partners-OpenVZ
R1Soft
partners-RV-Globalsoft
partners-Softaculous-auto-installer
partners-solusvm
partners-whmcs
services-cpanel
services-MySQL
services-Perl
services-swsoft-plesk
support-sevices-php