选择两种日期时间格式之间的所有记录 [英] Select all records between two datetime format

问题描述

我有这个查询，我需要选择两个日期之间的所有记录，mysql表是一个datetime格式。

我尝试过这个，但没有工作。

  select * from cdr 
 WHERE calldate BETWEEN'2012-12-01'AND'2012-12-03 '; 
  

解决方案

b

  select * from cdr 
 WHERE DATE（calldate）BETWEEN'20121201'AND'20121203'; 
  

I have this query, i need to select all records between two dates, the mysql table is a datetime format.

I tried this but it didn't work.

select * from cdr
 WHERE calldate BETWEEN '2012-12-01' AND '2012-12-03';

解决方案

Try this instead:

select * from cdr
WHERE DATE(calldate) BETWEEN '20121201' AND '20121203';

这篇关于选择两种日期时间格式之间的所有记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！