Help for this page

Select Code to Download


  1. or download this
    The conversion of a varchar data type to a datetime data type resulted
    + in an out-of-range value.
    
  2. or download this
    my $sth = $dbh->prepare_cached(<<SQL);
    update my_table set d_date = convert(datetime, ?, 120), name = ?
    SQL
    $sth->execute('2015-07-15', 'Foo');