YEAR in active record

Try this and see if it is what you want, not tested.

PHP Code:

$query = $this->db->select('SELECT DATE("{$data}") as required_DATE')
              ->where('numero_settimana', $numsettimana)
              ->where('giorno_settimanale', 'Domenica')
              ->db->get($tabella); 


What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )