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




Reply via email to