I am trying to store a SQL Server datetime into MySQL datetime field, but MySQL stores the date value as all zeros. I use this function to trim the fractional part from the SQL Server datetime, but get the same result when trying to store it in MySQL.
Dim tDate As String = sqlDate.ToString()
tDate = tDate.Substring(0, tDate.Length - 4)
View Complete Post