I am trying to update a column named td1 (smalldatetime) in a table
the sql query is :
Session("date") = Date.Now
Dim sSql As String = "update qa_segmentos set dt1 = '" & Session("date") & "'"
looking in the autos window I read :sSql "update qa_segmentos set dt1 = '20/10/10 18:11:43'" String
The error that I get is:
The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.
The statement has been terminated.
View Complete Post