cast
The CAST() function converts a value (of any type) into a specified datatype
The CAST() function converts a value (of any type) into a specified datatype
The TO_CHAR function converts a number or date to a string
The TO_DATE function accepts an argument of a character data type and converts this value to a DATETIME value
The TO_NUMBER function can convert a number or a character expression representing a number value to a DECIMAL data type
The TO_TIMESTAMP function converts char of CHAR , VARCHAR2 , NCHAR , or NVARCHAR2 datatype to a value of TIMESTAMP datatype