SYSDATE vs CURRENT_DATE
- From: Samuel Guiñales Cristobal <samuel.guinales@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 28 Feb 2012 11:36:31 +0100
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
Other related posts:
