Table of Contents
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.
When you’re running a business that relies on website traffic and sales to succeed. Then you need to keep it…
Migration! Yes, this word is very big in the web hosting industry and it has its importance. Especially for businesses…
The server is the backbone of the web hosting industry and it acts like a HERO in the web hosting…
Imagine you are on holiday having a cup of tea and browsing your website or blog.Then, what next?You will get…
The web hosting industry is growing every minute, day, and year. It has many terminologies that are important to understand…