AnsweredAssumed Answered

How to pass 'Date' as param in NSQL?

Question asked by Vishnu_Datta on Feb 16, 2016
Latest reply on Feb 17, 2016 by Vishnu_Datta

Hi, I'm new to CA PPM. As part of my work I has to pass 'Date' value as parameter. When hard coded the date value in NSQL gives no error but when passed as parameter, raises an error "ORA-01861: literal does not match format string" (The value being passed is in YYYY-MM-DD"T"HH:MI:SS format.). I tried converting the input value by TO_DATE, TO_TIMESTAMP_TZ but nothing works. Please suggest me what else should I do