SQL International Date Format(Insert / Update)

You will run into problems with SQL insert and updates if an application is hosted under a different regional setting than your development environemnt. To resolve this issue, if you are creating a string SQL statement then format the string as follows:

yyyy-mm-ddThh:mi:ss[.mmm]

Another option is to use parameterized queries.