CONVERSION FUNCTIONS IN SQL

•It converts data from one data type to another.
1)TO_CHAR (number / data [, format ])
–Converts a number or a data to VARCHAR2 value based on the format provided.
2)TO_NUMBER (char [, format ])
–Converts a character value with valid digits to numbers using format provided.
3)TO_ DATE (char [, format ])
–Converts a character value to date value based on the format provided. Default format is DD-MM-YY.
Post a Comment