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 <jtay...@oeinc.com> 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/jtayler%40oeinc.com > > This email sent to jtay...@oeinc.com
_______________________________________________ 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