Forums » General Discussion

Thread: Bad dates in 5.0

This question is not answered. Helpful answers available: 2. Answered answers available: 1.


Permlink Replies: 1 - Pages: 1 - Last Post: Jan 20, 2011 10:34 AM by: Guest Threads: [ Previous | Next ]
wwade

Posts: 1
Registered: 1/17/11
Bad dates in 5.0
Posted: Jan 17, 2011 4:55 PM
 
  Click to reply to this thread Reply

Inserting a bad date into a table generates the following exception when attempting to view the table in 5.0 (viewing works in 4.5):

Exception: MySql.Data.Types.MySqlConversionException

Message : Unable to convert MySQL date/time value to System.DateTime

Stack Trace:

at MySql.Data.Types.MySqlDateTime.GetDateTime()

at MySql.Data.MySqlClient.MySqlDataReader.GetValue(Int32 i)

at Quest.Toad.Db.Connection.ReadRow(IDataReader reader, FastTable datatable, FastReadOptions options, PrePostProcessHandler prePostProcessHandler)

at Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()

Right now I have to correct the date in 4.5 then view again





Guest
Re: Bad dates in 5.0
Posted: Jan 20, 2011 10:34 AM   in response to: wwade
  Click to reply to this thread Reply

This issue should be resolved in the soon to be released (Hopefully later today) Toad for MySQL 6.0 Beta.


Legend
Guru: 2001 + pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums