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:-