RE: best way to insert date/time into oracle table

[Kipp, James]

can i simply do :
foreach (@stats){
        chomp;
        ($host, $user $cpu_pct, $mem_pct = split( /,/ );
        $sth->execute(  sysdate(),  $host, $user $cpu_pct, $mem_pct );
}

or do i have to do another query like
select SysDate from DUAL;

thanks Michael !!


>
>
> > what are my options for inserting DATE/TIME into each record ?
>       SYSDATE works fine for us here.  Make sure your oracle
> server has
> the correct system time/date.
>
> Cheers,
>
> Michael
>
>