Answers for "date format in where clause in codeigniter"

date between query in codeigniter

$this->db->where('sell_date BETWEEN "'. date('Y-m-d', strtotime($start_date)). '" and "'. date('Y-m-d', strtotime($end_date)).'"');

date format in codeigniter

$sampleDate = '2019-01-02';

$convertDate = date("d-m-Y", strtotime($sampleDate));

  

print_r($convertDate);