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]
