Hi
I want to insert records from an array iteration. not sure of the best way
to enter the date and time. i read the docs, but thought i would check to
see if someone has experience with this and could give some ideas. code..
--
my $sth = $dbh->prepare( "INSERT INTO stats VALUES (?,?,?,?,?)" )
        or die "Cannot prepare SQL statements from $DBI::errstr\n";

foreach (@stats){
        chomp;
        ($host, $user $cpu_pct, $mem_pct = split( /,/ );
        $sth->execute( DATE/TIME,$host, $user $cpu_pct, $mem_pct );
}
---
what are my options for inserting DATE/TIME into each record ?

Thanks
Jim

Reply via email to