#53 No support for MySQL TIMESTAMP type

closed-accepted
nobody
None
5
2007-03-02
2006-03-15
Anonymous
No

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.

Discussion

  • Nobody/Anonymous

    Adds support for a TimestampCol class for MySQL

     
  • Oleg Broytman

    Oleg Broytman - 2006-03-21
    • status: open --> open-invalid
     
  • Oleg Broytman

    Oleg Broytman - 2006-03-21

    Logged In: YES
    user_id=4799

    Please add documentation and tests.

     
  • Oleg Broytman

    Oleg Broytman - 2007-03-02

    Logged In: YES
    user_id=4799
    Originator: NO

    Applied in the revision 2361.

     
  • Oleg Broytman

    Oleg Broytman - 2007-03-02
    • status: open-invalid --> closed-accepted
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks