This content has been marked as final. Show 2 replies
So you have a page that has a radio button for EACH hour in a DAY? As apposed to using a List of Values to allow the user to select from? Or even a shuttle??
Please tell me this is April 1st all over again....
Hi,1 person found this helpful
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