sql - Comparing Date field with specific datetime in oracle

Question

I have a table with a Date field time_process like '1/11/2021 5:10:16 AM'.

I want to select records has time_process >= '1/11/2021 05:00:00 AM' But when I query:

select * from DATA_RUN where time_process >= '1/11/2021 05:00:00 AM'

Has error:

[1]: ORA-01843: not a valid month

How can I compare this Date field with specific datetime?

Answer 1

You should use to_date to convert string to date as follows:

select * from DATA_RUN 
   where time_process >= To_date('01/11/2021 05:00:00 AM', 'mm/dd/yyyy hh:mi:ss AM')