我想在一个表中查找具有特定日期的日期列的所有记录，目前我正在尝试此查询，

SELECT     *
FROM      Table_ABC
WHERE     DateCreated CONTAINS 24/10/2012

但它不起作用

最佳答案

如果 DateCreated 列是 DATETIME 类型，您应该尝试:

SELECT     *
FROM      Table_ABC
WHERE     YEAR(DateCreated) = 2012
AND       MONTH(DateCreated) = 10
AND       DAY(DateCreated) = 24

或者只是

SELECT     *
FROM      Table_ABC
WHERE     DATE(DateCreated) = "2012-10-24"

https://stackoverflow.com/questions/13048141/