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
For example, if you want to record the time a row was
CREATE TABLE test (
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
time_added TIMESTAMP DEFAULT CURRENT_TIMESTAMP
The CURRENT_TIMESTAMP and NOW() functions are not
supported with the DATETIME column.
Log in to post a comment.