MySQL now() change timezone
mysql, php, timezone
Solution
You would want to go ahead and use the `CONVERT_TZ()` function in MySQL. It's based off the Olson database which your operating system uses.
Here is the documentation.
Problem
I'm using the following INSERT statement: ``` INSERT INTO messages SET `to` = '".$to."', `from` = '".$this->userid."', `title` = '".$title."', `message` = '".$message."', `created` = NOW() ``` However, it uses my server time (America/Montreal). I want time zone of Asia (Asia/Calcutta) Is this possible with the same query?