My client and db timezones are set as follows:
db > select dbtimezone from dual;
DBTIME
------
+00:00
db > select sessiontimezone from dual;
SESSIONTIMEZONE
---------------------------------------
+01:00
but when I query I get the following. I was expecting the dbtime to be UTC i.e. 7:47am
I should add I am running on a standalone laptop for study purposes.
db > select to_char(sysdate,'FMdd-MONTH-yyyy hh:mi') TIME from dual;
TIME
--------------------------------------------------
6-MAY-2014 8:47
db > select to_char(current_date,'FMdd-MONTH-yyyy hh:mi') TIME from dual;
TIME
--------------------------------------------------
6-MAY-2014 8:48
Just ran this (@11:43am) and expected 'SYSTIMESTAMP' to output UTC time (i.e. 10:43am) not '+01:00' ????
db > select dbtimezone from dual;
DBTIME
------
+00:00
db > select systimestamp from dual;
SYSTIMESTAMP
-------------------------------------
06-MAY-14 11.43.17.451000 +01:00
Message was edited by: Gusora