The conversion of a char data type to a datetime data type resulted in an out-of-range datetime sql server error

This can be caused by either not getting the date / time format correct in the VB or by the SQL login not having
the correct local specified for UK it should be set to British English

The format of the date/time should be

Dim Now As DateTime = DateTime.Now()
''2003-12-23 22:12:00'
DateString = "'" & Now.Day() & "-" & Now.Month() & "-" & Now.Day() & " " & Now.Hour() & ":" & Now.Minute() & ":00'"

There is also an interesting article by Srinath MS on devx.com which talks about something similar here

< Prev