Mysql比较两个日期时间字段 [英] Mysql Compare two datetime fields

问题描述

我想比较两个日期和时间，我想要所有结果 from tbl where date1 >日期2

I want to compare two dates with time, I want all the results from tbl where date1 > date2

Select * From temp where mydate > '2009-06-29 04:00:44';

但它只是比较日期而不是时间.它给了我今天日期的所有结果集

but it is just comparing dates not time. it is giving me all the result set of today's date

'2009-06-29 11:08:57'
'2009-06-29 11:14:35'
'2009-06-29 11:12:38'
'2009-06-29 11:37:48'
'2009-06-29 11:52:17'
'2009-06-29 12:12:50'
'2009-06-29 12:13:38'
'2009-06-29 12:19:24'
'2009-06-29 12:27:25'
'2009-06-29 12:28:49'
'2009-06-29 12:35:54'
'2009-06-29 12:36:54'
'2009-06-29 12:49:57'
'2009-06-29 12:58:04'
'2009-06-29 04:13:20'
'2009-06-29 04:56:19'
'2009-06-29 05:00:23'
'2009-06-29 05:04:26'
'2009-06-29 05:08:17'
'2009-06-29 05:26:57'
'2009-06-29 05:29:06'
'2009-06-29 05:32:11'
'2009-06-29 05:52:07'

提前致谢！

推荐答案

您要作为示例显示的查询是:

The query you want to show as an example is:

SELECT * FROM temp WHERE mydate > '2009-06-29 16:00:44';

04:00:00 是凌晨 4 点，所以您显示的所有结果都在之后出现，这是正确的.

04:00:00 is 4AM, so all the results you're displaying come after that, which is correct.

如果您想在下午 4 点之后显示所有内容，则需要在查询中使用正确的 (24hr) 表示法.

If you want to show everything after 4PM, you need to use the correct (24hr) notation in your query.

为了让事情更清楚，试试这个:

To make things a bit clearer, try this:

SELECT mydate, DATE_FORMAT(mydate, '%r') FROM temp;

这将显示日期和 12 小时制.

That will show you the date, and its 12hr time.

这篇关于Mysql比较两个日期时间字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！