my $sql = q{select * from accountaction where action_date > ?}; my $sth = $dbh->prepare($sql); $sth->execute('01-01-2006'); $sth->finish; #### my $sql = q{select * from accountaction where action_date > '01-01-2006'}; my $sth = $dbh->prepare($sql); $sth->execute(); $sth->finish; #### my $sql = q{select * from accountaction where action_date > ?}; my $sth = $dbh->prepare($sql); $sth->execute('2006-01-01'); $sth->finish;