RE: datetime fields?

From: Joel Trunick (joel.trunic..ebifysolutions.com)
Date: Tue Jun 21 2005 - 10:35:19 EDT

  • Next message: Mike Kienenberger: "Re: Getting relation with itself(same Object)"

    I'll vote for this as well (DateTime support)!

    J
    -----Original Message-----
    From: Robert Zeigler [mailto:rdzeigl...arizona.edu]
    Sent: Saturday, May 14, 2005 8:44 AM
    To: cayenne-use..bjectstyle.org
    Subject: Re: datetime fields?

    Andrus Adamchik wrote:
    >
    > On May 14, 2005, at 1:01 AM, Robert Zeigler wrote:
    >
    >> From looking at the modeler, it appears that only date, time, and
    >> timestamp fields are supported.
    >
    >
    > This only means that date, time, and timestamp are the choices JDBC
    > provides. MySQL itself can use any of its (compatible) column types.
    So
    > you can map your column in Cayenne as (JDBC) "TIMESTAMP", but on MySQL
    > end you can use (MySQL specific) type DATETIME, which I think is the
    > type you are looking for - nullable date + time.

    Yup... datetime is what I'm looking for. :)

    >
    > The only caveat is when you use CayenneModeler for schema generation,
    > you'll need to save the generated script, replace TIMESTAMP references
    > (a default mapping from JDBC to MySQL types used by Cayenne) to
    > DATETIME, and run it manually. Hopefully this part will become
    > customizable in Cayenne 1.2.
    >

    Thanks for the info. That helps considerably.
    Having it be customizable from the modeler would also be very nice. :)

    Robert

    This archive was generated by hypermail 2.0.0 : Tue Jun 21 2005 - 10:35:20 EDT