I have a MySQL data adapter and I am trying to query a table and place it in a DataSet. The problem I have is SOME of the time and DateTime values are being converted into C# TimeSpan variables rather than DateTime. I tried adding a CAST(timeVariable AS DATETIME) and the problem still exists. I tried to just import the Schema then change the data type in the dataset and this did not work either.
I am using the MySql.Data.MySqlClient objects to do the fill. Any Thoughts?