Java and WebObjects store all times in GMT (aka UTC) internally. So if your DB server is on UTC there should not be any conversions when the data is moved back and forth. When the date data is formatted in a human readable form, that is when the time zone comes into play. Try formatting with both the Java SimpleDateFormat (which I recommend using in any case) and NSTimestamp formatter. Any difference would indicate a bug in NSTimestampFormatter or in the underlying time zone data it is using. If they are both wrong, something else is going on.
Chuck On 2012-08-16, at 9:04 AM, Jesse Tayler wrote: > oh, that might be the trouble -- I didn't think about the database encoding. > > I'm using mysql, but I checked the db properties and found UTC? > > My server is EDT, or easter with daylight savings, for NYC. Unix reports Thu > Aug 16 12:03:04 EDT 2012 > > Should this be set to EDT? UTC is GMT right? That would be more like 8 hours > off, no? > > Anyone know how Mysql should get setup or if this is ok? > > thanks! > > <Screen Shot 2012-08-16 at 11.59.39 AM.png> > > On Aug 16, 2012, at 12:55 AM, WebObjects TORAcom <w...@toracom.net> wrote: > >> Hi Jesse, >> >> The date with the problem is stored in a database? >> >> We got some problems with Postgresql. Date and timezone on server was ok but >> not in postgres. >> >> We found this instruction: >> >> ALTER DATABASE postgres SET timezone to 'Mexico/General'; >> >> That made the trick. >> >> Hope this helps. >> >> Miguel Torres. >> >> On 14/08/2012, at 11:29, Jesse Tayler <jtay...@oeinc.com> wrote: >> >>> My server time is off a suspicious negative one hour, which I presume to be >>> a daylight savings problem. >>> >>> UNIX returns the date I expect. >>> >>> So, I'd guess this is a Java or WO settings issue? >>> >>> A long time ago, on a server far away, >>> >>> there were some issues with missing timezone files used by Java and >>> installed by WO or vice versa? >>> >>> Does anyone know where best to find out what's responsible for the date >>> being returned an hour off to my client? >>> >>> >>> >>> _______________________________________________ >>> Do not post admin requests to the list. They will be ignored. >>> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) >>> Help/Unsubscribe/Update your Subscription: >>> https://lists.apple.com/mailman/options/webobjects-dev/wo%40toracom.net >>> >>> This email sent to w...@toracom.net >>> >> >> >> >> >> > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net > > This email sent to ch...@global-village.net -- Chuck Hill Senior Consultant / VP Development Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/gvc/practical_webobjects _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
