如何使用活动记录查询指定时间之间的日期的SQL [英] How to query sql with active record for dates between specified times
问题描述
我有一个数据库,我只想提取日期在指定范围内的某些行.我不确定如何在活动记录中正确执行此操作.现在看来,我正在活动记录查询中运行标准的mysql查询.我希望这会让您对我的需求有所了解.
I have a database that I want to pull only certain rows that have dates in specified ranges. I'm not sure how to do this properly in active record. Right now it looks like I'm running a standard mysql query inside of an active record query. I hope this gives you the idea of what I'm looking for.
我还希望能够在今天之前(包括今天和将来的3天)获得包含任何内容的行.
I would also like to be able to get rows with anything before today, including today and 3 days in the future.
$query = $this->db->query("SELECT * FROM 'topics_list' . 'topic date' WHERE DATE(order_datetime) BETWEEN '2012-10-01' AND '2012-10-3'");
推荐答案
这是方法.但是根据数据库中的DATE格式,必须更改2012-10-01
和2012-10-03
this is the way . but according to the DATE format you have in the database you have to change 2012-10-01
and 2012-10-03
$this->db->select('*');
$this->db->from('topics_list');
$this->db->where('order_datetime <','2012-10-03');
$this->db->where('order_datetime >','2012-10-01');
$result = $this->db->get();
这篇关于如何使用活动记录查询指定时间之间的日期的SQL的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!