my $SQL = "SELECT ID, DDATE FROM MYTEMP4
           WHERE to_char(DDATE,'mm/dd/yyyy') LIKE ?";
my $sth = $dbh->prepare($SQL);
$sth->execute('08/%/2015');