** H E L P ** Auto inserting date/Time (SQL*FORMS 2.3)

Hi,

        I'm going bersek here. All I want to do is have a form insert the date and time into a DATE column in a table when the new record is commited.

        My best attempt yet has this in a PRE-INSERT trigger:-

select to_date(to_char(sysdate,'hh24:mi:ss dd-mon-yy'),

                'hh24:mi:ss dd-mon-yy')

        where :time is the field on the form (and in the table) that I want the date and time stored in. Unfortunately this ALWAYS results in the time part being set to 00:00:00

        What's going on ? What am I doing wrong ? How can I get it right ?

                Please help,

                        Desperate of UK Received on Wed Jun 23 1993 - 13:24:29 CEST