Re: Need Help with SQL Plus in 8i
From: Keld Nielsen <keldnielsen_at_image.dk>
Date: Mon, 11 Feb 2002 21:48:21 +0100
Message-ID: <dcW98.5920$5L3.354260_at_news010.worldonline.dk>
Date: Mon, 11 Feb 2002 21:48:21 +0100
Message-ID: <dcW98.5920$5L3.354260_at_news010.worldonline.dk>
Yep, one can see that you RTFM - try - to_char(sysdate,'hh24mmss') or even better '(999) 999-9999'
"Sergiu gp" <sergiugp_at_aol.com> wrote in message
news:20020211013056.00851.00001058_at_mb-cu.aol.com...
> Thanks a bunch, what I wanted was to take the numeric string of char
datatype
> and just place the paranthesis and dash formatting. I guess that the
substr
> function does that.
>
> Best
>
> Sergiu
Received on Mon Feb 11 2002 - 21:48:21 CET