Hi Jesse, The problem we got with postgresql was in the period of time day light time in U.S. begins because in Mexico begins later.
We found the datetimes stored in our database with a one hour offset during that period, once daylight begins in Mexico everything gets normal . The server timezone was correct (America / Mexico City) but for one reason time zone in postgres was Chicago (or something else). I am not sure if this is your case. Hope this helps. On 16/08/2012, at 11:27, Jesse Tayler <[email protected]> wrote: > > If my app output logs report the correct time, which they do: > > Aug 16 12:21:17 WOMan[2002] DEBUG NSLog - === Commit Internal > Transaction > > then, WO / Java have a correct timezone too. > > therefore, this must be mysql? > > > > On Aug 16, 2012, at 12:04 PM, Jesse Tayler <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 ([email protected]) >>>> Help/Unsubscribe/Update your Subscription: >>>> https://lists.apple.com/mailman/options/webobjects-dev/wo%40toracom.net >>>> >>>> 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: >> https://lists.apple.com/mailman/options/webobjects-dev/jtayler%40oeinc.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: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
