Select Dates where time is less or equal to '12:00' Oracle
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?
No comments:
Post a Comment