Process of Changing MySQL timezone

[linux tech]

As default <a href="http://www.bodhosting.com/ " target="_blank" title=" MYSQL " style="color:#000000;text-decoration:none;">MYSQL</a> timezeon is set as GMT - 7 / MST. You can set one 1 timezone per mysql daemon.

All you require to do is to change the following SQL queries SELECT NOW(); with SELECT DATE_ADD(NOW(), INTERVAL 2 HOUR); This will result in Eastern Standard Time.

If you require to set in PST, then replace the following -

SELECT DATE_SUB(NOW(), INTERVAL 1 HOUR);

In order to set MSN into EST, follow the following -

SELECT unix_timestamp() + (3600 * 2);
SELECT FROM_UNIXTIME(UNIX_TIMESTAMP() + (3600 * 2));

However, in accordance to your application. you will require to do the following -

a) Search for places in cost where the time and date is displayed in the browser. Then, use a defined function change in order to add or subtract the numbers of hours before displaying.