Re: Return value of tz_offset

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.

-- 
Sybrand Bakker
Senior Oracle DBA