Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » FunctionsRSS Feeds

CONVERSION FUNCTIONS

Posted By: Mina Schmidt     Category: Oracle     Views: 2153

This article explains about conversion functions.

TO_NUMBER 

Converts char value expressing a number to a NUMBER datatype.
UPDATE customers SET rating=rating + TO_NUMBER(SUBSTR('$10',2,2));

TO_CHAR(date,[format])

      - converts a value of a DATE datatype to CHAR value.
      - default date format is "DD-MON-YY"
SELECT TO_CHAR(odate,'Month DD,YYYY') "New Date Format" FROM Orders;
  
Share: 

 
 
 

Didn't find what you were looking for? Find more on CONVERSION FUNCTIONS Or get search suggestion and latest updates.

Mina Schmidt
Mina Schmidt author of CONVERSION FUNCTIONS is from Frankfurt, Germany.
 
View All Articles

Related Articles and Code:


 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!