Errors in conversion of date (and time) data

User, date Message
User: claud108
Posted: Tue, 09 Dec 08 11:32
Category: jHeidi (discontinued)
1 posts since Tue, 09 Dec 08 		Hi,

Thank you for bringing HeidiSQL into the Linux world.

When ran it, I faced the following erros in viewing certain tables with data:
java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date

java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 3 to TIMESTAMP

Claud
User: anse
Posted: Tue, 09 Dec 08 23:53
1822 posts since Fri, 07 Apr 06 		Already posted here.
 

Please login to leave a reply, or register at first.