Re: CAST vs. TO_NUMBER or TO_CHAR or TO

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 11 Oct 2007 16:31:19 -0700
Message-ID: <bf46380710111631k1e5cea70pbf318ae8ebb16f21@mail.gmail.com>

On 10/11/07, David Taft <oradbt054_at_gmail.com> wrote:
>
> Looks useful for figuring out things like elapsed time. No doubt there
> are other ways to do the same thing and I'm sure there are many other uses
> for cast. I'm glad to have been made aware of this function.
>
>

Very nice.

I will have to make use of this to replace a function of mine that does the same thing, albeit somewhat less elegantly.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Oct 11 2007 - 18:31:19 CDT

Re: CAST vs. TO_NUMBER or TO_CHAR or TO_DATE or ...