date format not accepted in query
Hi all,
What is the correct way to filter a select statement based on date. I am receiving this error:
ORA-01858: a non-numeric character was found where a numeric was expected
or ORA-01849: hour must be between 1 and 12
In where clause I have
AND POH.CREATION_DATE BETWEEN to_DATE(:P_DATE_FROM, 'YYYY/MM/DD hh:mi:ss')) AND TO_DATE(:P_DATE_TO, 'YYYY/MM/DD hh:mi:ss')
data entered is 2023/01/01 00:00:00 and 2023/12/01 00:00:00 comes from FND_STANDARD_DATE parameter value from concurrent program.