|
From: SourceForge.net <no...@so...> - 2006-03-21 09:57:38
|
Patches item #1450570, was opened at 2006-03-15 20:59 Message generated for change (Comment added) made by phd You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540674&aid=1450570&group_id=74338 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: None Group: None Status: Open >Resolution: Invalid Priority: 5 Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) Summary: No support for MySQL TIMESTAMP type Initial Comment: SQLObject does support a DatetimeCol for MySQL, but does not have support for the TIMESTAMP column type. Databases will usually support either one or the other (or neither and a CHECK type), but MySQL uses both DATETIME and TIMESTAMP and they each perform a different role. For example, if you want to record the time a row was initially created: CREATE TABLE test ( id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, value INT, time_added TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); The CURRENT_TIMESTAMP and NOW() functions are not supported with the DATETIME column. ---------------------------------------------------------------------- >Comment By: Oleg Broytmann (phd) Date: 2006-03-21 12:57 Message: Logged In: YES user_id=4799 Please add documentation and tests. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540674&aid=1450570&group_id=74338 |
