mysql比较两个时间字段_Mysql比较两个datetime字段

我想要比较两个日期与时间，我想要所有的结果从tbl where date1> date2

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

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

'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'

提前致谢！