[Eclipsesql-bugs] [ eclipsesql-Bugs-1574620 ] Cannot convert value '0000-00-00' to TIMESTAMP

[SourceForge.net <no...@so...>]

Bugs item #1574620, was opened at 2006-10-10 15:54
Message generated for change (Settings changed) made by spackers
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=725495&aid=1574620&group_id=132863

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Interface (example)
Group: None
>Status: Closed
>Resolution: Out of Date
Priority: 5
Private: No
Submitted By: AndrewB (andybaumhauer)
Assigned to: Nobody/Anonymous (nobody)
Summary: Cannot convert value '0000-00-00' to TIMESTAMP

Initial Comment:
Executing SQL on a table containing date/timestamp
values with all zeros, 'the special value' indicating
no date, results in an error "Cannot convert value
'0000-00-00' from column %d to a TIMESTAMP".  This
problem makes most of the interface unusable.

CREATE TABLE IF NOT EXISTS bugtest (
	RecordID MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
	Created DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
	PRIMARY KEY (RecordID)
) ENGINE = InnoDB;


"As of MySQL 5.0.2, MySQL does not accept timestamp
values that include a zero in the day or month column
or values that are not a valid date. The sole exception
to this rule is the special value '0000-00-00 00:00:00'."

----------------------------------------------------------------------

Comment By: Manni Heumann (mannih2001)
Date: 2007-07-17 09:42

Message:
Logged In: YES 
user_id=565464
Originator: NO

Bump.

This can be (clumsily) worked around by adding a DATE_FORMAT statement to
select statements. But there is no workaround for previews.

----------------------------------------------------------------------

Comment By: Stefan Broetz (broetz)
Date: 2006-10-24 08:18

Message:
Logged In: YES 
user_id=1222550

Have to tried to add zeroDateTimeBehavior=convertToNull to
your JDBC URL?

See
http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=725495&aid=1574620&group_id=132863