[SQL-CVS] [ sqlobject-Patches-1450570 ] No support for MySQL TIMESTAMP type

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

Patches item #1450570, was opened at 2006-03-15 09:59
Message generated for change (Tracker Item Submitted) made by Item Submitter
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: None
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.

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=540674&aid=1450570&group_id=74338