From: SourceForge.net <no...@so...> - 2007-10-16 08:54:20
|
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 |
From: SourceForge.net <no...@so...> - 2008-01-15 03:39:35
|
Bugs item #1574620, was opened at 2006-10-10 08:54 Message generated for change (Comment added) made by stzzo 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: Stzzo (stzzo) Date: 2008-01-14 19:39 Message: Logged In: YES user_id=1364270 Originator: NO Thank-you broetz! Adding "?zeroDateTimeBehavior=convertToNull? to the URL works at least for SELECT statements. I haven't tested it with all the other functions. Example: jdbc:mysql://mysql.yourdomain.com/username?zeroDateTimeBehavior=convertToNull ---------------------------------------------------------------------- Comment By: Manni Heumann (mannih2001) Date: 2007-07-17 02: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 01: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 |