Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Return value of tz_offset

Re: Return value of tz_offset

From: sybrandb <sybrandb_at_gmail.com>
Date: 14 Sep 2006 01:24:23 -0700
Message-ID: <1158222263.318959.198010@i3g2000cwc.googlegroups.com>

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
Received on Thu Sep 14 2006 - 03:24:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US