Re: DATETIME type in mysql?

From: Jürgen Saar (jsaa..eb.de)
Date: Fri Oct 15 2004 - 17:20:17 EDT

  • Next message: Bryan Lewis: "Re: exception in ContextCommit"

    > In mysql the TIMESTAMP type does not act like a normal TIMESTAMP. I'll quote:
    > ============
    > The TIMESTAMP column type provides a type that you can use to automatically
    > mark INSERT or UPDATE operations with the current date and time. If you
    > have multiple TIMESTAMP columns in a table, only the first one is updated
    > automatically.
    > ============
    >
    > This means when you don't specify a value for TIMESTAMP mysql just
    > overwrites the current value with a new time value. That's kind of stupid.

    No that is not stupid, because if you use it the way it is planned by mysql
    the current time is only set on insert. I used it in former times (php) to
    get the information of creation of an information. In such a scripting language
    it is much more difficult to get a proper handling of such informations.

    With cayenne this is very much easier, because you can put the handling
    of timestamps in the validation-methods of the dataobject. So you have
    one single point of timestamp management

    ________________________________________________________________
    Verschicken Sie romantische, coole und witzige Bilder per SMS!
    Jetzt neu bei WEB.DE FreeMail: http://freemail.web.de/?mc=021193



    This archive was generated by hypermail 2.0.0 : Fri Oct 15 2004 - 17:20:24 EDT