$db = DBI->connect('dbi:ODBC:'.$DSN, $UID, $PWD, {PrintError => 0,RaiseError => 1,LongReadLen => 65536});
...
$FetchPagesWithUpdatedTranslations = $db->prepare('exec FetchPagesWithUpdatedTranslations ?, ?'); # product_id, time
...
my $res = $FetchPagesWithUpdatedTranslations->execute( $prodId, SQLtime($FILES{':'.$section}));
...
sub SQLtime {
	my $time = shift() || 0;
	my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst)
		= localtime($time);
	$year+=1900;
	$mon++;
	return "$year-$mon-$mday $hour:$min:$sec";
}

##</code><code>##

CREATE PROCEDURE FetchPagesWithUpdatedTranslations (
	@ProductId Int,
	@Date datetime = NULL
) AS
...

##</code><code>##

DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification (SQL-22018)(DBD: st_execute/SQLExecute err=-1) at ...

##</code><code>##

CREATE PROCEDURE FetchPagesWithUpdatedTranslations (
	@ProductId Int,
	@DateS varchar(20) = NULL
) AS
...