Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Date parameter is throwing an error
Summary: A date value is stored in the screen_entry_value field.
I created two date parameters (p_week_start, p_week_end).
I am trying to use the screen_entry_value in my where condition.
and to_date(peevf.screen_entry_value, 'YYYY-MM-DD HH24:MI:SS') between :p_week_start and :p_week_end
But then I get the below error.
What am I doing wrong?
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):24D
Code Snippet (add any code snippets that support your topic, if applicable):
Tagged:
0