Re: Date & Time with time zone

"Wei Wei" <wei725(at)lycos(dot)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