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.
- 26 Users Found This Useful
Related Articles
Can I change the name of a MySQL database?
The name of a MySQL database consists of a prefix, which is your cPanel username, followed by a...
How can I change my MySQL database collation?
Usually you will be interested in changing your MySQL collation in order to solve problems with...
How can I empty a MySQL database?
The easiest way to empty a MySQL database is through phpMyAdmin. Once in phpMyAdmin, select the...
How to change the database engine of a MySQL database table?
In this article we will show you how to change the database engine of a MySQL table. Let's...
How to change the password of a Mysql user in cPanel?
If you have already created a MySQL user through the cPanel -> Mysql Databases tool you may...
Powered by WHMCompleteSolution
