Capture objects changed based on LAST_DDL_TIME

Hello All

In our 19.21 database we are trying to identify the objects that were compiled / change for some reasons using the LAST_DDL_TIME but no matter what we try we are not getting the correct results so definitely we are doing something wrong

We would really appreciate if someone can shed some light / guide us on how to use that criteria to filter out the date

For example we need to look for objects whose LAST_DDL_TIME was today between 9 AM and 3 PM

select * from dba_obect where

last_ddl_time BETWEEN 

to_date('03-04-2024 09:00:00','mm-dd-yyyy hh24:mi:ss')