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

Home -> Community -> Usenet -> c.d.o.server -> Re: Should TO_CHAR be replaced by high level code with pl/sql calls?

Re: Should TO_CHAR be replaced by high level code with pl/sql calls?

From: DJ <nospamplease_at_goaway.com>
Date: Sat, 22 Nov 2003 22:51:19 -0000
Message-ID: <KLRvb.5412$4Y6.1584@newsfep4-winn.server.ntli.net>

"Pete Finnigan" <plsql_at_petefinnigan.com> wrote in message news:fzCHksAt19v$Qxle_at_peterfinnigan.demon.co.uk...
> > the benefit to writing your own would rank somewhere
> >around the decrease in performance one would expect to see with the line
> >voltage to the computer dropped from 120V to 118V. ;-)
>
> Good evening Daniel,
>
> Thinking along, I did remember once seeing a company do their own date
> conversions from DATE to CHAR in C after it had been selected. This was
> back in 7.1.6 days though and written before that! and the application
> was very date intensive and they said it was faster to read the "raw"
> date and then convert it "off-line". Don't know if it really was or not!
>
> Anyway its academic really as i don't really see the point of it all, it
> was just interesting to consider the "why"!!, if the voltage dropped to
> 118v here we would have a much bigger performance problem as we start
> with 240v...:-)
>

Im gonna be picky here, but we use 230v in the uk, we went down 10v a few years ago to be in line with europe:-) Received on Sat Nov 22 2003 - 16:51:19 CST

Original text of this message

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