获取两个日期之间的所有记录 [英] Get all records between two dates

问题描述

如何获取mysql表中两个日期字段日期之间的所有记录.我在我的应用程序中使用代码点火器.

How can i fetch all records between two date field dates in mysql table.Am using code igniter for my application.

从日期选择器输入开始日期和结束日期，需要提取所有行> =开始日期和< =结束日期

Am entering start date and end date from date picker , need to fetch all rowas >= startdate and <= end date

我的代码:-

 $this->db->where('start_date <= ',$start_date);
 $this->db->where('end_date >= ',$end_date);

我的查询:-SELECT * FROM table WHERE start_date < ='2016-04-13'AND end_date > ='2016-04-19'

My query :- SELECT * FROM table WHERE start_date <= '2016-04-13' AND end_date >= '2016-04-19'

这仅从表中获取一行.

请帮助

推荐答案

您需要执行以下操作...

U need to do something like this...

 $this->db->select("DATE_FORMAT(date, '%m/%d/%Y') as Urdate",FALSE);
 $this->db->from('table');
 $this->db->where("DATE_FORMAT(date,'%Y-%m-%d') > '2013-01-01'",NULL,FALSE);

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