I have found the the timestamp returned by systimestamp is in the new timezone when connecting to the database with a local bequeath connection, but when the connection is done via TNS it is in US Eastern time. Still investigating. Pete -- //www.freelists.org/webpage/oracle-l