How to query sql with active record for dates between specified times

Question

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.

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'");

what is the format you stored DATE in the database

Kanishka Panamaldeniya
– Kanishka Panamaldeniya

2012-08-24 02:00:15 +00:00
Commented Aug 24, 2012 at 2:00 — Kanishka Panamaldeniya
– Kanishka Panamaldeniya, Commented Aug 24, 2012 at 2:00

Kanishka Panamaldeniya · Accepted Answer · 2012-08-24 02:01:51Z

20

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();

answered Aug 24, 2012 at 2:01

Kanishka Panamaldeniya

17.6k31 gold badges128 silver badges195 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alireza · Accepted Answer · 2012-08-24 01:51:45Z

3

You can specify you $where and use active records

$where = "DATE(order_datetime) BETWEEN '2012-10-01' AND '2012-10-3'";
$this->db->where($where)->get('table_name');

answered Aug 24, 2012 at 1:51

Alireza

5,6939 gold badges42 silver badges50 bronze badges

Comments

user2079277 · Accepted Answer · 2017-06-10 09:18:36Z

3

`$where = array(
  "order_datetime <" => "2012-10-03",
  "order_datetime >" => "2012-10-01"
);
$this->db->select("*")->get_where("topics_list" , $where)`

answered Jun 10, 2017 at 9:18

user2079277

272 bronze badges

Comments

Usman Zia · Accepted Answer · 2019-03-20 18:57:23Z

2

You can specify you $where and use active records

$this->db->group_start()
          ->or_where("product_order.generate_date >= ","$start_date")
          ->or_where("product_order.generate_date <","$end_date + INTERVAL 1 DAY")
          ->group_end();

answered Mar 20, 2019 at 18:57

Usman Zia

211 bronze badge

Comments

louk · Accepted Answer · 2018-03-30 14:47:44Z

1

To use the "Between" by respecting the Query builder of CI:

$this->db->where("order_datetime BETWEEN '2018-10-01' AND '2018-10-3'","", FALSE);

answered Mar 30, 2018 at 14:47

louk

976 bronze badges

Collectives™ on Stack Overflow

How to query sql with active record for dates between specified times

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related