Just tried that, and when I display the date in a WOTextField with a dateformat
formatter, the time show up in GMT instead of America/Montreal, even if I call
this.setTimeZone(TimeZone.getTimeZone("America/Montreal")); in Session.java.
To make it short, I want to store the time in GMT, but want to show and edit it
in the local timezone of the user. Me starting to think that I should use a
long that store the epoch :-/
> any reason you can't just run your app in GMT via the user.timezone property?
>
> ms
>
> On Mar 7, 2011, at 9:10 AM, Pascal Robert wrote:
>
>> It look like H2 stores the time in the system's timezone instead of GMT. For
>> example, a NSTimestamp which time is 13:40:58 Etc/GMT is stored as 08:40:58
>> because my system is set to America/Montreal (GMT -5). According to H2
>> documentation:
>>
>> " If the time zone is not set, the value is parsed using the current time
>> zone setting of the system. Date and time information is stored in H2
>> database files without time zone information. If the database is opened
>> using another system time zone, the date and time will be the same. That
>> means if you store the value '2000-01-01 12:00:00' in one time zone, then
>> close the database and open the database again in a different time zone, you
>> will also get '2000-01-01 12:00:00'. Please note that changing the time zone
>> after the H2 driver is loaded is not supported. "
>>
>> I really need to store the dates in GMT, or at least store the timezone
>> offset, but I didn't find how to tell H2 to store it. I was thinking it
>> might be because the formatter that ERH2PlugIn.formatValueForAttribute()
>> calls is not storing the timezone offset, but when debugging, I don't even
>> reach that formatter, so the problem doesn't seem to be there.
>>
>> --
>> Pascal Robert
>> [email protected]
>>
>> AIM/iChat : MacTICanada
>> LinkedIn : http://www.linkedin.com/in/macti
>> Twitter : pascal_robert
>>
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list ([email protected])
>> Help/Unsubscribe/Update your Subscription:
>> http://lists.apple.com/mailman/options/webobjects-dev/mschrag%40pobox.com
>>
>> This email sent to [email protected]
>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
