Errors in conversion of date (and time) data

[expired user #3796]'s profile image [expired user #3796] posted 15 years ago in jHeidi (discontinued) Permalink

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

ansgar's profile image ansgar posted 15 years ago Permalink
Already posted here.

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