AnsweredAssumed Answered

ORA-01840: input value not long enough for date format ...

Question asked by Durga Revanth Tiruvakkad on Nov 24, 2016
Latest reply on Dec 1, 2016 by Venkata Ramana Reddy Kanaparthy

Hi ,

 

I am Getting error  ORA-01840: input value not long enough for date format in sql select node and delay node  in RSA IMG version 6.9.1.113500 P16

 

while using the below query

 

select to_char(to_DATE('${jobUserData_STR_DATE}', 'YYYY-MM-DD')) as Delay_date FROM dual.

 

Please let me know what would be the issue is it a bug am i really making mistakes in query?

Outcomes