También he probado con lo siguiente pero sigue sin funcionar:
Código SQL
[-]
select * from cabvent
where
extract(year from feccve) = extract(year from :fecha) and
extract(month from feccve) = extract(month from :fecha) and
extract(day from feccve) = extract(day from :fecha) and
extract(hour from feccve) = extract(hour from :hora) and
extract(minute from feccve) = extract(minute from :hora) and
extract(second from feccve) = extract(second from :hora)
aparece un mensaje de error "Type mismatch in expression"