SYSDATE vs CURRENT_DATE
From: Samuel Guiñales Cristobal <samuel.guinales_at_gmail.com>
Date: Tue, 28 Feb 2012 11:36:31 +0100
Message-ID: <CAF=AZ3D3RKSPFFQzNwyG0v5eGS+EYK9ELcy+xX0Pvnk9VUaUJg_at_mail.gmail.com>
Hello,
Date: Tue, 28 Feb 2012 11:36:31 +0100
Message-ID: <CAF=AZ3D3RKSPFFQzNwyG0v5eGS+EYK9ELcy+xX0Pvnk9VUaUJg_at_mail.gmail.com>
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_at_gmail.com> «La vida es breve; el arte, largo; la ocasión, fugaz; la experiencia, engañosa; el juicio, difícil.» Hipócrates, Aforismos, I, 1 -- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 28 2012 - 04:36:31 CST