curdate 和now,如何使MySQL的NOW（）和CURDATE（）函数使用UTC？

I want to make it so calls to NOW() and CURDATE() in MySQL queries return the date in UTC. How do I make this happen without going through and changing all queries that use these functions?

解决方案

Finally found what I was looking for...

In my.cnf,

[mysqld_safe]

timezone = UTC

I was putting this option under [mysqld], and mysql was failing to start.

Calling "SET time_zone='+0:00';" on every page load would also work, but I don't like the idea of calling that query on every single page load.