Re: Storing GMT dates?

From: Alexander Lamb (dev) ("Alexander)
Date: Tue Feb 26 2008 - 08:25:03 EST

  • Next message: Michael Gentry: "Re: Storing GMT dates?"

    Maybe I can rephrase the question: does Cayenne do any kind of
    transformation when storing Date objects in TIMESTAMP fields?

    If so, how can I control this?

    Thanks,

    Alex

    Le 25 févr. 08 à 16:17, Alexander Lamb a écrit :

    > Hello,
    >
    > Using Cayenne 3.0M3, MySQL 5.
    >
    > I have a field which is a TIMESTAMP. It maps to a Java.util.Date
    > class in Java.
    >
    > If I do a myObject.setMyTimestamp(new Date()) I will store the local
    > date.
    >
    > I would like to store a GMT date.
    >
    > I tried doing this:
    >
    > Calendar cal = Calendar.getInstance(TimeZone.getTimeZone("GMT"));
    >
    > myObject.setMyTimestamp(cal.getTime());
    >
    > but again, I am back to the local time. Indeed, a trace shows "cal"
    > is correctly set at the GMT value, but cal.getTime() is back to the
    > local time (or at least the printout is, but it is as if Cayenne
    > took the formated value and not the actual date value).
    >
    > How can I solve this problem?
    >
    > Thanks,
    >
    > Alex
    > --
    > Alexander Lamb
    > Founding Associate
    > RODANOTECH Sàrl
    >
    > 4 ch. de la Tour de Champel
    > 1206 Geneva
    > Switzerland
    >
    > Tel: 022 347 77 37
    > Fax: 022 347 77 38
    >
    > http://www.rodanotech.ch
    >
    >
    >



    This archive was generated by hypermail 2.0.0 : Tue Feb 26 2008 - 08:25:38 EST