SQL Conversion functions are single row functions which are capable of typecasting column value, literal or an expression .
3 Types of Functions.
TO_CHAR
TO_NUMBER
TO_DATE .
Three functions which perform cross modification of data types.
TO_CHAR() : The function converts both numerical data and date data to datatype varchar2.
TO_DATE() : The function is used to convert character data to the date datatype.
TO_NUMBER() : The function converts data of type char or varchar2 to type number.
3 Types of Functions.
TO_CHAR
TO_NUMBER
TO_DATE .
Three functions which perform cross modification of data types.
TO_CHAR() : The function converts both numerical data and date data to datatype varchar2.
TO_DATE() : The function is used to convert character data to the date datatype.
TO_NUMBER() : The function converts data of type char or varchar2 to type number.
No comments:
Post a Comment