"Wei Wei" <wei725@lycos.com> writes:
> A returned value of "select new()" is correct, but the TZ is -7 where
> the TZ of OS is set to Pacific Day Time Saving Time.
That sounds like PG is working like it's supposed to.
> The application is
> written with Java. And I use the Java API Calendar class to match
> with the PG data type timestamp with time zone through Hibernate. The
> date log message is from the getTime and getTimezone methods of the
> class. Both are correct at this point.
> I do some search on various forums of the java.sun.com. It might
> relate with the jdbc driver. Shall I move this issue to the jdbc mailing
> list?
Yeah, it sounds like a JDBC issue. Search their archives before
posting; I seem to recall having seen similar discussions there before.
regards, tom lane
