Re: useDaylightTime() ??
Re: useDaylightTime() ??
- Subject: Re: useDaylightTime() ??
- From: WebObjects TORAcom <email@hidden>
- Date: Thu, 16 Aug 2012 12:17:12 -0500
| 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.
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@hidden> 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>
|
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden