Conversions


cast

The CAST() function converts a value (of any type) into a specified datatype

func.to_char

The TO_CHAR function converts a number or date to a string

func.to_date

The TO_DATE function accepts an argument of a character data type and converts this value to a DATETIME value

func.to_number

The TO_NUMBER function can convert a number or a character expression representing a number value to a DECIMAL data type

func.to_timestamp

The TO_TIMESTAMP function converts char of CHAR , VARCHAR2 , NCHAR , or NVARCHAR2 datatype to a value of TIMESTAMP datatype

Last modified December 20, 2022 at 10:05 AM EST: remove sitemap priority (56709da)