my $sth = $dbh->prepare_cached(<<SQL);
update my_table set d_date = convert(datetime, ?, 120), name = ?
SQL
$sth->execute('2015-07-15', 'Foo');