如何从MySQL中的datetime中减去3个小时？ [英] How to subtract 3 hours from a datetime in MySQL?

问题描述

我收到一个datetime字段，目前在查询中：

I get a datetime field, that's currently in the query as:

SELECT DATE_FORMAT(x.date_entered, '%Y-%m-%d') AS date FROM x ORDER BY date ASC

我想做什么是从该日期（GMT问题）减去3小时，但是我不能在PHP中执行，因为PHP只知道日期部分，而不是时间。

What I want to do is to subtract 3 hours from that date (GMT issues), but I can't do it in PHP as PHP only knows the date part, not the time.

推荐答案

mySQL有 DATE_SUB（） ：

mySQL has DATE_SUB():

SELECT DATE_SUB(column, INTERVAL 3 HOUR)....

但是不会更好，整理出潜在的时区问题？

but would it not be better to try and sort out the underlying time zone issue instead?

这篇关于如何从MySQL中的datetime中减去3个小时？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！