CONVERSION FUNCTIONS in SQL

CONVERSION FUNCTIONS  :- The conversion functions convert a value from one data type to another.These functions just return the converted value and does not makes any changes in the database.

     The varous conversion functions are described below.

1-Command:- TO_CHAR(date conversion)

Purpose:- This date based function is used for transforming a DATE value into a VARCHAR2 value using a specified date format.

Example:-

2-Command:- TO_CHAR(number conversion)

Purpose:- This number based function is used for transforming numeric value into a varchar2 value optionally using a specified number format.

Example:-

3-Command:- TO_DATE

Purpose:- It converts a character string to its date equivalent.

Example:- 

4-Command:- TO_NUMBER

    Purpose:- It is used to convert a character value to a number value.

    Example:-