azz ho risolto togliendo le parentesi...

codice:
DROP VIEW IF EXISTS `meseview`; 
 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` 
SQL SECURITY DEFINER      VIEW 'meseview`  	AS  		
(select datapartenza as datadainserire, concat(glmese(month(datapartenza)),' ', year(datapartenza)) as chedata 
from contratti group by month(datapartenza)) 
union  
(select datapartenza as datadainserire, concat(glmese(month(datacontratto)),' ', year(datacontratto)) as chedata 
from contratti group by month(datacontratto))