The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
##</code><code>##

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