SQL Developer (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center