Return value of tz_offset

From: Björn Wächter <bwc_at_p3-solutionsKILL_SPAM.de>
Date: Thu, 14 Sep 2006 08:44:28 +0200
Message-ID: <4msc2cF7l0i2U1@news.dfncis.de>

I'm facing a problem if I try to append a string to the return value of tz_offset like this:

select 'start' || tz_offset('+02:00') || 'end' test from dual

TEST

---

start+02:00

But if I do this:

select 'start' || substr(tz_offset('+02:00'),1,6) || 'end' test from dual

TEST

---

start+02:00end

it works fine.

Any Ideas?

Björn Received on Thu Sep 14 2006 - 01:44:28 CDT