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

ORA-01830: date format picture ends before converting entire input string

Accepted answer
19
Views
2
Comments

Summary:

Getting above error while running query with date parameter instead of parameter if i give sysdate it is working fine


Content (required):


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


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

select ROUND(TO_DATE(:CUT_OFF )-TRUNC(add_months(trunc(add_months(SYSDATE , -3), 'yyyy'), 3)),0)+2 from dual

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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