Alle: 

SELECT * FROM DBA.OBJECTS WHERE ident is not null

Tagesaktuelle: 

SELECT * FROM DBA.OBJECTS WHERE car_torent = 1 and (date_registration is not null and date_registration <= today()) and (date_unregister is null or date_unregister > today())