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