CURRENT_TIMESTAMP VS SYSTIMESTAMP problem
741904Mar 29 2010 — edited Mar 29 2010Hello to all,
I try to ajust the session time in ordre to make it fitting well with the country where I live: Bruxelles. But when I change the session nothing happend.
Those are my values:
SELECT CURRENT_TIMESTAMP, SYSTIMESTAMP, LOCALTIMESTAMP FROM DUAL;
29-MAR-10 12.57.05.473971 AM -07:00
29-MAR-10 12.57.05.473953 AM -07:00
29-MAR-10 12.57.05.473971 AM
When I do: alter session set time_zone= '-2:00';
SELECT CURRENT_TIMESTAMP, SYSTIMESTAMP, LOCALTIMESTAMP FROM DUAL;
29-MAR-10 12.58.24.014152 AM -07:00
29-MAR-10 12.58.24.014139 AM -07:00
29-MAR-10 12.58.24.014152 AM
Nothing seems to have been changed. How could I mofify my session time to fit the time of my country?
(In fact it's currently 18h14 at my place)
Thank you for any help.
Claude