"Wei Wei" <wei725@xxxxxxxxx> 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
