At 09:43 16/03/01 -0500, Raymond Chui wrote: Delayed as I only read General once in a while - jdbc mails should go to the jdbc list. >I have PostgreSQL jdbc7.0-1.2.jar JDBC drive. > >I found out if a column of a table is Timestamp data type > >Properties p = new Properties(); >p.put("PGTZ", "GMT"); > >This does not take effect when you do >SELECT/UPDATE/INSERT/DELETE (QUID). >It gives me the local time zone. > >This should be the same as set environment >"export PGTZ=GMT" or "setenv PGTZ GMT" >in UNIX, right? Nope... PGTZ is a libpq thing, and jdbc has nothing to do with libpq. >I have to do >connection = driver.connect('myjdbcURL", p); >Statement st = connection.createStatement(); >st.execute("SET TIME ZONE 'GMT'"); Correct method. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]