Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Should TO_CHAR be replaced by high level code with pl/sql calls?
"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