This content has been marked as final. Show 2 replies
The source of this page item is database column TIME with a format of TIMESTAMP(0). Format mask of DD-MON-YYYY, default value of to_date(:"P5_TIME_TMP",'DD-MON-YYYY');.The ' "P5_TIME_TMP" ' in this expression doesn't seem right to me. Shouldn't it be just :P5_TIME_TMP? There may be other problems, but why not try this to_date(:"P5_TIME_TMP",'DD-MON-YYYY');. in SQL Workshop > SQL Commands to see what you get? Make it work there first.
Well, let me add more. You are probably familiar with this error. In this case, it means the conversion could not find "DD-MON-YYYY" type data in your variable/expression. So, I think of two possibilities: 1) The data is not what you think it is so you need to display it to see exactly what it is. Or, 2) the expression specifying the data is not what you want / expect. In this case, I think 2) is true. I often run these code pieces in the SQL Commands window so I can see exactly how they are working / not working in APEX.
Edited by: Howard (... in Training) on Apr 16, 2013 7:59 AM