Retrieve the current date and time in a particular time zone
suggest changeThis 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();
Found a mistake? Have a question or improvement idea?
Let me know.
Table Of Contents