Comments

• Is that an answer? Did you try to create a DateTimeOffset CommandParameter with a DefaultValue from the wizard and click "Next"?

  in CommandParameter: Failed to convert parameter value from a Variant to a DateTimeOffset Comment by nba May 2017
• Thank you, but I'm asking for DateTimeOffset, i.e. DataType="34" (DataType="7" stands for Image, not Date, nor DateTime). I tried ISO8601 format (yyyy-mm-ddThh:mi:ss.mmmZ) or any other SSMS formats, but it simply doesn't work. By the way with …

  in CommandParameter: Failed to convert parameter value from a Variant to a DateTimeOffset Comment by nba May 2017