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

Home -> Community -> Mailing Lists -> Oracle-L -> CAST vs. TO_NUMBER or TO_CHAR or TO_DATE or ...

CAST vs. TO_NUMBER or TO_CHAR or TO_DATE or ...

From: Rumpi Gravenstein <rgravens_at_gmail.com>
Date: Thu, 11 Oct 2007 09:49:31 -0400
Message-ID: <9c9b9dc90710110649i6086e04do68af4c54f6254fe@mail.gmail.com>


I've been looking at the Oracle CAST function vs. a TO_NUMBER or TO_CHAR or .... Where both the CAST and TO_ functions result in equivalent answers, is there a preferred choice?

--

Rumpi Gravenstein

--

http://www.freelists.org/webpage/oracle-l Received on Thu Oct 11 2007 - 08:49:31 CDT

Original text of this message

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