擅长:python、mysql、java
<p>您可以使用此转换帮助您将日期更改为另一个时区</p>
<p>MYSQL服务器8:</p>
<pre><code>CONVERT_TZ(timeperiod, 'UTC', 'Asia/Tehran')
</code></pre>
<p>或</p>
<pre><code>WHERE CONVERT_TZ(timeperiod, 'UTC', '{$this->timezone}')
NOT BETWEEN
{$timeperiods['today_start']} AND {$timeperiods['today_end']}
</code></pre>