19/01/2022 11:31:02  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Report MÉTODO->uf_familiar_personal ERROR->Invalid query: ERROR:  syntax error at or near "("
LINE 2:                    AGE('2022-01-19',sno_personal.fecnacper) ...
                              ^
Whole query: SELECT sno_personal.codper,sno_personal.apeper, sno_personal.nomper, sno_personal.fecnacper  
			                AGE('2022-01-19',sno_personal.fecnacper) AS edad_format,
			                EXTRACT(YEAR FROM AGE('2022-01-19',sno_personal.fecnacper)) AS edad
					  FROM sno_personal, sno_familiar  WHERE sno_personal.codemp = '0001'    AND (sno_personal.estper='1' ) AND (sno_familiar.nexfam='C'  OR sno_familiar.nexfam='P'  OR sno_familiar.nexfam='H'  OR sno_familiar.nexfam='E' ) AND (sno_familiar.sexfam='M'  OR sno_familiar.sexfam='F' ) AND (sno_personal.sexper='M'  OR sno_personal.sexper='F' ) 	AND sno_personal.codemp = sno_familiar.codemp    AND sno_personal.codper = sno_familiar.codper  GROUP BY sno_personal.codper, sno_personal.apeper, sno_personal.nomper, sno_personal.fecnacper    ORDER BY sno_personal.codper 

19/01/2022 11:31:06  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Report MÉTODO->uf_familiar_personal ERROR->Invalid query: ERROR:  syntax error at or near "("
LINE 2:                    AGE('2022-01-19',sno_personal.fecnacper) ...
                              ^
Whole query: SELECT sno_personal.codper,sno_personal.apeper, sno_personal.nomper, sno_personal.fecnacper  
			                AGE('2022-01-19',sno_personal.fecnacper) AS edad_format,
			                EXTRACT(YEAR FROM AGE('2022-01-19',sno_personal.fecnacper)) AS edad
					  FROM sno_personal, sno_familiar  WHERE sno_personal.codemp = '0001'    AND (sno_personal.estper='1' ) AND (sno_familiar.nexfam='C'  OR sno_familiar.nexfam='P'  OR sno_familiar.nexfam='H'  OR sno_familiar.nexfam='E' ) AND (sno_familiar.sexfam='M'  OR sno_familiar.sexfam='F' ) AND (sno_personal.sexper='M'  OR sno_personal.sexper='F' ) 	AND sno_personal.codemp = sno_familiar.codemp    AND sno_personal.codper = sno_familiar.codper  GROUP BY sno_personal.codper, sno_personal.apeper, sno_personal.nomper, sno_personal.fecnacper    ORDER BY sno_personal.codper