Select Dates where time is less or equal to '12:00' Oracle

Question

I require a query that selects rows where the time is less or equal to 12:00 I had something like this in mind:

SELECT daterow FROM datecolumn WHERE daterow <= TO_DATE('12:00, HH24:MI')

However i get an error:

ORA-01843: not a valid month

How would i go about to get all rows that have a time less than 12:00 mid-day?

Answer 1

Try this,

SELECT daterow FROM datecolumn WHERE daterow <= TO_DATE('12:00', 'HH24:MI');