Mysql -> Date/Time & tracking creation/modification time

From: Fredrik Liden (flide..ranslate.com)
Date: Thu Feb 24 2005 - 15:30:30 EST

  • Next message: René Kulschewski: "AW: AW: Problem with Date/Time-part"

    I have one table that I'd like to track
    the date/time entries are created and the date/time they are modified.

    For the date_created I'm thinking I could use mysql's DATETIME or Timestamp and have a default now() function. Does anyone have any easy way to use now() during object.updates?
    Or how do you keep track of this information?

    Also, does anyone know what the difference is between DATETIME and Timestamp.
    Can I manually change Timestamp to DATETIME in a mysql table and Cayenne will work even though java.util.Timestamp is mapped to TIMESTAMP in the database?

    Fredrik

    This archive was generated by hypermail 2.0.0 : Thu Feb 24 2005 - 15:30:03 EST