How can I get timestamp in Oracle Forms 6i

 Hi,

I have a date field in a base table block. I want to save the current date and time to the corresponding column in the table when a particular event happens.

I have tried the following and none seem to work.

1. I have assigned the sysdate to the variable-

    :block.submit_date := TO_DATE(TO_CHAR(SYSDATE,'MM/DD/YY HH24:MI:SS'), 'MM/DD/YY HH24:MI:SS') 

2. I have set the datatype of the item in the block to Datetime.

3. I have put a fomat mask of MM/DD/YY HH24:MI:SS in the properties of the item.