Re: Return value of tz_offset

From: Björn Wächter <bwc_at_p3-solutionsKILL_SPAM.de>
Date: Thu, 14 Sep 2006 13:21:09 +0200
Message-ID: <4mss95F7lkhbU1@news.dfncis.de>

sybrandb wrote:

> Björn Wächter wrote:

>> 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

> 
> What is the outcome of
> select dump(tz_offset('+02:00'))
> from dual
> /
> 
> This should provide a hex dump of the result, so you can identify any
> spurious trailing characters.
> 

The result is:

select dump(tz_offset('+02:00')) from dual

DUMP(TZ_OFFSET('+02:00'))

---

Typ=1 Len=7: 43,48,50,58,48,48,0

The string is 0 terminated.
I think that's the problem. Can this be operating system dependent?

Björn Received on Thu Sep 14 2006 - 06:21:09 CDT