$sth = $dbh->prepare("UPDATE Schedules SET Date = 'NOW' WHERE ID = $id") or die "Couldn't prepare statement: $DBI::errstr; stopped"; #### my @cur_time = localtime(); my $now = sprintf("%4d-%02d-%02d", $cur_time[5]+1900, $cur_time[4]+1, $cur_time[3]);