Unable to insert/update dates into MSSQL tables

And you still have the same error from your DB ?
What is the type of the column in your DB ? datetime or datetime2 ?
I think you should use datetime2, as recommended by MSSQL documentation, to be able to parse the timezone.