Hello, Version: Oracle 9.2.0.8.0 OS: HP-UX preoas B.11.23 U ia64 3960232104 unlimited-user license problem: one hour less in sysdate only when we make conections using listener in all databases. alter session set nls_date_format='DD-MON-YYYY hh24:mi:ss'; SELECT SYSDATE,CURRENT_DATE FROM DUAL; SYSDATE CURRENT_DATE -------------------------------- ------------------------------------ 27-FEB-2012 16:44:22 27-FEB-2012 17:44:23 SQL> SELECT DBTIMEZONE, SESSIONTIMEZONE FROM DUAL; DBTIME SESSIONTIMEZONE -------- ------------------- +01:00 +01:00 - OS: TZ=MET-1METDST date=17:44:23 very strange behavior, happends with all database in this machine Regards --- Samuel Guiñales Cristobal <samuel.guinales@xxxxxxxxx> «La vida es breve; el arte, largo; la ocasión, fugaz; la experiencia, engañosa; el juicio, difícil.» Hipócrates, Aforismos, I, 1 -- //www.freelists.org/webpage/oracle-l