22/03/2021 19:22:56  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->revrecepcion MÉTODO->uf_siv_obtener_recepcion ERROR->Invalid query: ERROR:  date/time field value out of range: "22/03/2021"
LINE 22:         AND r.fecrec BETWEEN '22/03/2021' AND '22/03/2021'  ...
                                      ^
HINT:  Perhaps you need a different "datestyle" setting.
Whole query: SELECT r.*,
		                sno_personal.nomper AS nompersupent, sno_personal.apeper AS apepersupent,
		                c.codcliente, c.nombre_cliente,
						tco.*,
						p.nompro,
						toi.*, 
			    		CASE WHEN r.tipclipro='PROV' THEN p.nompro
						     ELSE c.nombre_cliente 
							  END AS nomclipro,
						CASE WHEN r.tipclipro='PROV' THEN p.cod_pro
							 ELSE c.codcliente 
						END AS codclipro  
		           FROM siv_recepcion r 
				   LEFT JOIN sno_personal ON sno_personal.codper = r.codpersupent
				   LEFT JOIN siv_tipoconcepope tco ON tco.codtipconope = r.codtipconope
				   LEFT JOIN siv_tipoopeinv toi ON toi.opeinv = tco.opeinv
				                               AND toi.codprodoc = tco.codprodoc
				   LEFT JOIN rpc_proveedor p ON p.cod_pro = r.cod_pro
				   LEFT JOIN cxc_clientes c ON c.id_cliente = r.id_cliente
				 WHERE r.estrevrec=1  
				   AND r.estapr='1'
				    AND r.fecrec BETWEEN '22/03/2021' AND '22/03/2021'   
				   AND codalm IN
				 		(SELECT codintper FROM sss_permisos_internos
				   	  WHERE sss_permisos_internos.codemp =r.codemp
				     		AND codsis='SIV'
				 			AND codusu ='ADMINISTRADOR'  AND enabled=1) 
				 ORDER BY r.numordcom, r.numconrec