MySQL Handling Time Zones Retrieve the current date and time in a particular time zone.
Example
This fetches the value of NOW() in local time, in India Standard Time, and then again in UTC.
SELECT NOW();
SET time_zone='Asia/Kolkata';
SELECT NOW();
SET time_zone='UTC';
SELECT NOW();
