Well this could be a work around. Since the application is throwing an error we need to handle this on application and in DB we need to insert null
so at application side :
if(expirationTime==null)
{
sqldatenul = "January 1, 1753 ";
MyCommand.Parameters.AddWithValue("@expirationTime",sqldatenul);
}
else
{
MyCommand.Parameters.AddWithValue("@expirationTime",(expirationTime).ToUniversalTime());
}
And in Stroe Proc :
keep this check before insertion
if @expirationTime = 'January 1, 1753 '
begin
@expirationTime = null
end
hope this can work as work around.