如何从datetime列中选择日期？ [英] How to select date from datetime column?

问题描述

我有一个类型为datetime的列，其值如2009-10-20 10:00:00

我想从datetime中提取日期并写一个查询，如：

  SELECT * FROM 
 data 
 WHERE datetime ='2009-10-20' 
 ORDER BY datetime DESC 
  

以下是最好的方式吗？

  SELECT * FROM 
 data 
 WHERE datetime BETWEEN（'2009-10-20 00:00:00'AND '2009-10-20 23:59:59'
 ORDER BY datetime DESC 
  

解决方案

  WHERE DATE（datetime）=' 2009-10-20'
  

或尝试这个也可以看看它是否适用于
这是否有助于

WHERE datetime LIKE'2009-10-20％'

您不需要检查它是否正常工作。

I have a column of type "datetime" with values like 2009-10-20 10:00:00

I would like to extract date from datetime and write a query like:

SELECT * FROM 
data 
WHERE datetime = '2009-10-20' 
ORDER BY datetime DESC

Is the following the best way to do it?

SELECT * FROM 
data 
WHERE datetime BETWEEN('2009-10-20 00:00:00' AND '2009-10-20 23:59:59'
ORDER BY datetime DESC

This however returns an empty resultset. Any suggestions?

解决方案

WHERE DATE(datetime) = '2009-10-20'

or try this also and see whether it works on not. Does this helps

WHERE datetime LIKE '2009-10-20%'

You need to check whethere it works on not.

这篇关于如何从datetime列中选择日期？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！