Time in a DATE field

I use SYSDATE all the time to auto-populate date fields in various tables. Both through the use of the DEFAULT function on a column definition and through the use of Triggers applied to tables. Until now it was not necessary to save the exact time of a given transaction, only the date.
I know that using the TO_CHAR function and formating I can get the time out of SYSDATE " select TO_CHAR(sysdate,'fmHHMMSS') from dual; " but how do I put this time back into a date field?

Help, how can I change the load of a DATE field to save the time of the transaction by making use of the function SYSDATE?

Thanks for any assistance.

Paul Teague Received on Sat Dec 15 2001 - 14:09:21 CST