This content has been marked as final. Show 2 replies
Could it be that you do not have seconds in TO_CHAR format? Try
BTW, it is best create database trigger to populate audit columns.
:P3_LAST_UPDATE_DATE := to_date(sysdate,'DD-MON-RR HH24:MI:SS');
My Blog: http://dbswh.webhop.net/htmldb/f?p=BLOG:HOME:0
Th reason appears to be because I hadn't set a format mask on the item.
I have now set the format mask to match and it is now working.