MYSQL Query Issue in Codeigniter

High friends,

could you please help me to check date from datetime on mysql query in codeigniter

like

return $this->db->select("*")->from($this->db->dbprefix."notification")->where('date',date('Y-m-d'))->get()->result();

in database date is in this format date('Y-m-d h:i:s'); i am also trying by using like it is not working for me please anybody help me