使用php在mysql中的两个日期之间过滤数据 [英] filter data between two dates in mysql with php

问题描述

We want filter data between two dates. when we execute query then it return outer range of data to selected dates.

推荐答案

Select * from tables where CREATE_TIME > "2008-02-01" and CREATE_TIME < "2008-02-08"

请试试这个。

Please try this one.

类似

Something like

SELECT *
FROM `table`
WHERE `table_date` BETWEEN CAST('2014-12-20' AS DATE) AND CAST('2014-12-25' AS DATE);

这里有一些参考链接：

MySQL BETWEEN比较 [ ^ ]

MySQL CAST为 [ ^ ]

这篇关于使用php在mysql中的两个日期之间过滤数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！