DATE_FORMAT Search In Yii Framework 1.0

This tutorial will help you to find the result using DATE_FORMAT() function. ‘DATE_FORMAT’ function is used to convert the integer to date format value. I add the source code for this type of date search. In addCondition i used DATE_FORMAT function to filter the result.

public function search()
{
	$criteria=new CDbCriteria;
	// condition for >= single date
	if(!empty($this->from_date) && empty($this->to_date)) {	       
		$this->from_date=date('Y-m-d',strtotime($this->from_date));
        $criteria->addCondition(
			"DATE_FORMAT(checkin_time, '%Y-%m-%d') >= '$this->from_date'"
		);
	}  
	// condition for <= single date
    elseif(!empty($this->to_date) && empty($this->from_date)) {
		$this->to_date=date('Y-m-d',strtotime($this->to_date));
        $criteria->addCondition(
			"DATE_FORMAT(checkin_time, '%Y-%m-%d') <= '$this->to_date'"
		);
	}
	// condition between two date
    elseif(!empty($this->from_date) && !empty($this->to_date)) {
		$this->from_date=date('Y-m-d',strtotime($this->from_date));
        $this->to_date=date('Y-m-d',strtotime($this->to_date));
        $criteria->addCondition(
			"DATE_FORMAT(checkin_time, '%Y-%m-%d') >='$this->from_date' 
			and 
			DATE_FORMAT(checkin_time, '%Y-%m-%d') <= '$this->to_date'"
		);
	}
	return new CActiveDataProvider($this, array(
		'criteria'=>$criteria,
	));	
}