这是我的约会数据;
来自:2013年1月9日
致:22-01-2013(格式固定)
如何格式化列日期send_date_time到d-m-Y ..下面是我的查询:
$filter = "and DATE_FORMAT(send_date_time,'%d-%m-%Y') BETWEEN '08-01-2012 12:00:00' and '22-01-2013 12:00:00' ";
但是当我尝试使用此(下面)查询时,上面的查询失败,是的可以工作:
$filter = "and send_date_time BETWEEN '2013-01-08 12:00:00' and '2013-01-22 12:00:00' ";
完整查询
$get_transaction_history = ("select * from `sms_sendlog` where store_id='".$store."' ".$filter." order by id desc");
柱:
Colum Name : send_date_time
e.g value : 2012-10-22 10:19:36
解决方法:
应该是这样的
$filter = "and send_date_time BETWEEN DATE_FORMAT('08-01-2012 12:00:00','%d-%m-%Y') AND DATE_FORMAT('22-01-2013 12:00:00','%d-%m-%Y') ";
标签:php,mysql,select,date-format
来源: https://codeday.me/bug/20190620/1246042.html