SELECT * FROM table WHERE t BETWEEN '2010-11-29' AND '2010-12-29'
$this->db->from('table')->where('t >=', '2010-11-29')->where('t <=', '2010-12-29');
$this->db->from('table')->where('t BETWEEN "2010-11-29" AND "2010-12-29"');