timezone region in timestamp

From: Mike <mikedo_at_gmx.net>
Date: 15 Sep 2003 12:23:15 -0700
Message-ID: <aca25bc2.0309151123.6a5eab2b@posting.google.com>

Hi,

I tried this statement:

select to_char(current_timestamp, 'tzd:tzh:tzm:tzr') from dual;

TO_CHAR(CURRENT_TIMESTAMP,'TZD:TZH:TZM:TZR')

---

:+02:00:+02:00

Why do I not get my local timezone region?

Thanks, Mike Received on Mon Sep 15 2003 - 14:23:15 CDT