我一直在尝试使用SQL NOW()函数来更新一个表中的日期字段,但是什么也没有发生,我认为DBI会忽略那个值。代码如下:
dbUpdate($id, (notes => 'This was an update', filesize => '100.505', dateEnd => 'NOW()'));
而该函数的作用是:
sub dbUpdate {
my $id = shift;
my %val_hash = @_;
my $table = 'backupjobs';
my @fields = keys %val_hash;
my @values = values %val_hash;
my $update_stmt = "UPDATE $table SET ";
my $count = 1;
foreach ( @fields ) {
$update_stmt .= "$_ = ? ";
$update_stmt .= ', ' if ($count != scalar @fields);
$count++;
}
$update_stmt .= " WHERE ID = ?";
print "update_stmt is : $update_stmt\n";
my $dbo = dbConnect();
my $sth = $dbo->prepare( $update_stmt );
$sth->execute( @values, $id ) or die "DB Update failed : $!\n";
$dbo->disconnect || die "Failed to disconnect\n";
return 1;
}#dbUpdate
如您所见,这是一个“动态”生成的SQL查询,因此我不知道SQL日期函数(例如now())在哪里使用。
在给定的示例中,SQL查询将会是:
UPDATE backupjobs SET filesize = ? , notes = ? , dateEnd = ? WHERE ID = ?
使用参数值
100.55, This was an update, NOW(), 7
但是日期列仍显示0000-00-......。有什么解决办法吗?