ORA-01830: date format picture ends before converting entire input string
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:
0