APEX

Hi

I have a interactive report + form page on a table (with attribute called LAST_UPDATE_DATE). I am populating this column with the help of form page item by

 TO_DATE(SYSDATE, 'DD-MON-RRRR HH24:MI:SS') 

But this populates the date as: 23-SEP-09 12.00.00.000000 AM , the time being always,12.00.00.000000 AM

Workarounds tried:

 
1. Instead of TO_DATE(SYSDATE, 'DD-MON-RRRR HH24:MI:SS'), I used the expression 
TO_DATE(TO_CHAR(SYSDATE, 'DD-MON-RRRR HH24:MI:SS'), 'DD-MON-RRRR HH24:MI:SS')
which works fine when executing directly in DB.
2. Altering the session by : alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS';

I am still facing the same problem. Please help.

Thanks
Bhavesh