-
October 16th, 2012, 10:23 AM
#1
Casting Time DateTime MySQL to C#
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?
-
October 17th, 2012, 06:33 AM
#2
Re: Casting Time DateTime MySQL to C#
Could you show some code? Where you tried adding a cast? Where TimeSpan appears in the code?
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|