Re: Time in a DATE field

As Thomas said, but with an example

" select TO_CHAR(<field name goes here>,'fmHHMMSS') from ,<table name goes here>; "

"Paul" <pst5183_at_cavtel.net> wrote in message news:3C1BADF1.1000103_at_cavtel.net...
> 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 Mon Dec 17 2001 - 14:48:32 CST