Forums » General Discussion

Thread: Error appears for non valid date values, datetime [1 Attachment]


Permlink Replies: 1 - Pages: 1 - Last Post: Jan 20, 2011 10:50 AM by: Mauritz
Haakan

Posts: 1
Registered: 3/4/08
Error appears for non valid date values, datetime [1 Attachment]
Posted: Jan 7, 2011 1:39 AM
  Click to reply to this thread Reply

<*>[Attachment(s) from =?iso-8859-1?Q?H=E5kan_Askengren?= included below]

Error in object explorer, trying to view data in tables with datetime columns.

Working in 4.6.0 but not in 5.0 (no error in 4.6)
When datetime column contains null values or old dates (0001-01-01) for not null columns error apears, conversionException.


best regards
Håkan Askengren





Mauritz

Posts: 314
Registered: 8/23/07
Re: Error appears for non valid date values, datetime [1 Attachment]
Posted: Jan 20, 2011 10:50 AM   in response to: Haakan
  Click to reply to this thread Reply

This should be fixed in the soon to be released (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