September 2000
Intermediate to advanced
418 pages
11h 5m
English
Content preview from Oracle SQL: the Essential Reference
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
5.5. Conversion Functions
Conversion functions allow the conversion of values from one datatype to another. The most commonly used conversion functions are:
TO_CHAR
Converts a date or a numeric value to a character string.
TO_NUMBER
Converts a character string to a numeric value.
TO_DATE
Converts a character string to a date value.
There are a number of other conversion functions available; all are included in this section.