Re: what am i doing wrong with this qualifier
Re: what am i doing wrong with this qualifier
- Subject: Re: what am i doing wrong with this qualifier
- From: Paul Hoadley <email@hidden>
- Date: Thu, 27 Jan 2011 09:05:02 +1030
On 26/01/2011, at 11:09 PM, Johann Werner wrote:
> Just a thought: There was a discussion back on december 2010 about the JDBC driver for PostgreSQL converting timestamps between timezones behind your back. Could it be that your 00:00:00 timestamp gets shifted changing the date eventually and then reset to 00:00:00? Have a look at http://wiki.objectstyle.org/confluence/display/WO/Project+WONDER-Frameworks-PostgresqlPlugin
At first glance, that does seem like what is happening. Ted, you could try setting "-Duser.timezone=UTC" as a launch argument which will at least prevent the JDBC driver from adjusting the timestamp, and remove one potential source of error from the equation. (Obviously a way better idea is using proper 1-day resolution types, which is where you seem to be heading!)
--
Paul.
http://logicsquad.net/
_______________________________________________
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