combining date and time columns for query in codeigniter

Question

I have a database table with separate date and time column. To get particular I execute query in mysql in following manner

select * from table_A where empID='A1201' order by TIMESTAMP(date,time) desc limit 1

How can I convert this particular for codeigniter? I tried in following manner but it's not working

$column = 'TIMESTAMP(date,time)';
$this->db->select('*');
$this->db->where('empID', 'A1201');
$this->db->from('table_A');
$this->db->order_by($column, 'desc');
$this->db->limit(1);
$query = $this->db->get();
$data = $query->result();
return $data;

This query result in error since it executes in following manner ORDER BY TIMESTAMP(date DESC, time) DESC while the correct way is ORDER BY TIMESTAMP(date,time) DESC. What will be the correct way for codeigniter using active record

Atural · Accepted Answer · 2018-07-18 13:20:33Z

1

try this

$query = $this->db
    ->select('*')
    ->where('empID', 'A1201')
    ->from('table_A')
    ->order_by($column, 'desc', false)
    ->limit(1)
    ->get();

order by comes with a 3rd option - just set this to false

You can get more infos about that in their documentation here

answered Jul 18, 2018 at 13:20

Atural

5,4505 gold badges21 silver badges36 bronze badges

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

Collectives™ on Stack Overflow

combining date and time columns for query in codeigniter

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related