Active CodeIgniter record compares date

Question

I have a column in db with a date stored as mm / dd / yyyy. I need to capture all rows with dates exceeding a certain date. (For example, any date after 01/01/2012). How to do this using active recording?

I tried

$this->db->select('DATE_FORMAT(date, '%mm/%dd/%Y') as mydate'); $this->db->where('mydate >','01/01/2013'); 

Answer 1

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