Re: ORA-06502 using stored procedure
Date: 2000/07/19
Message-ID: <8l3ob1$88c$1_at_nnrp1.deja.com>#1/1
In article <sn7fil5no539_at_corp.supernews.com>,
"Matt B." <mcb_at_fightspam.sd.znet.com> wrote:
> "Lars Sjöström" <lasse.sjostrom_at_telia.com> wrote in message
> news:WTKc5.627$967.196138496_at_newsb.telia.net...
> >I think, but I can not check now, that the TO_CHAR is only intended
for
> conversion between DATE and CHAR.
>
> No - TO_CHAR is valid with numbers as well as dates.
>
> -Matt
select to_char( to_date(whole_number,'J'),'Jsp') from dual
works for integers within Julian dat range, not sure about real numbers. I guess you could multiply the real number by 10, 100 or 1000 to convert to integer though.
Hope this helps
Gareth
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Jul 19 2000 - 00:00:00 CEST