如何使MySQL的NOW()和CURDATE()函数使用UTC? [英] How do I make MySQL's NOW() and CURDATE() functions use UTC?

问题描述

我想这样做，因此对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...

在my.cnf中，

[mysqld_safe]
timezone = UTC

我将此选项放在[mysqld]下，而mysql无法启动.

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

呼叫"SET time_zone ='+ 0:00';"在每个页面加载中也可以使用，但是我不喜欢在每个页面加载时都调用该查询的想法.

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.

这篇关于如何使MySQL的NOW()和CURDATE()函数使用UTC?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！