Re: NSTimestamp data
Re: NSTimestamp data
- Subject: Re: NSTimestamp data
- From: Art Isbell <email@hidden>
- Date: Tue, 18 Feb 2003 10:42:11 -1000
On Tuesday, February 18, 2003, at 05:46 AM, Paul-Liviu Petrus wrote:
I am making an upgrade from WO 4.5 to 5.1. I have queries which are
based on datetime fields (now modelled through NSTimestamp). Those
queries don't work anymore because all the date fields are converted to
GMT in the fetch. A date which was saved as '2002-10-01 00:00:00' will
be fetched as '2002-09-30 22:00:00 Etc/GMT'. Naturally, the results are
completely wrong.
WO 5 uses JDBC to access databases unlike prior WO versions that used
native DB libraries. Unfortunately, JDBC doesn't support timestamp
with time zone data, so all timestamps must be stored in GMT. This
works fine in many cases, but if time zone adjustments are required,
you'll need to perform timestamp adjustments programmatically which
might require storing the time zone description (e.g., "America/Los
Angeles") as an attribute.
Art
http://homepage.mac.com/aisbell/
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.