I want to compare two date which is stored in database.and for this,i have write a query like this.

 $rs = $this->db->select('jb_emp.*')
                    ->from('jb_emp')
                    ->where('jb_emp.employer_id',$id)
                    ->where('jb_emp.status','Active')
                    ->where('jb_emp.save_draft',NULL)
                    ->where('date(jb_emp.create_date)<=','date(jb_emp.start_date)')
                    ->where('date(jb_emp.end_date) > ', date('Y-m-d h:m:s'))
                    ->get()->result_array();
                    echo "
" ;print_r($rs);die();


According to query, i should get the data where create date is less than start date,but i'm getting just opposite to it(where create date is greater than to start date)and if i uses greater than sign instead of less than,i don't get any data.

Here i just want to access the data where create date is less than or equal to start date.

Can anyone help me to get this? Any help will be appreciated.
Thanks in advance