You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Why occurs this error "ORA-01841: (full) year must be between -4713 and 9999, and not be 0"?

Summary:

When I try to do a SQL with a parameter date occurs this error "ORA-01841: (full) year must be between -4713 and 9999, and not be 0"

SQL:

select *

from

GL_DAILY_RATES


where

CREATION_DATE = 'Date' 

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!