مكتبة الشروحات

How to change the MySQL timezone

When you develop your website, you may have to compare a certain date/time with the current date/time on the server.

The timezone on servers is CST. 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.

0 أعضاء وجدوا هذه المقالة مفيدة

مكتبة الشروحات

أقسام الشروحات

أقسام الشروحات

How to change the MySQL timezone

مقالات مشابهة

الدعم الفني

مكتبة الشروحات

أقسام الشروحات

أقسام الشروحات

How to change the MySQL timezone

مقالات مشابهة

الدعم الفني

Generate Password