xiecsuk
Member
I have a variable declared as Date in VB.NET. I have a field declared as DateTime in an SQL table. I just cannot seem to SELECT, INSERT or UPDATE the field without getting a "System Error". I have tried CAST to try and convert the variable as I read or write it, without any luck. I have resorted to using a string field in SQL and DateValue in VB.NET until I can sort it out.
Can anybody tell me how to maintain the DateTime field type in SQL and how to CAST the variable properly.
Can anybody tell me how to maintain the DateTime field type in SQL and how to CAST the variable properly.