Book Contents

Book Index

Next Topic

Home

Formatting Functions

These formatting functions provide a powerful set of tools for converting various data types (DATE/TIME, INTEGER, FLOATING POINT) to formatted strings and for converting from formatted strings to specific data types. These functions all follow a common calling convention: the first argument is the value to be formatted and the second argument is a template that defines the output or input format.

Exception: The TO_TIMESTAMP function can take a single double precision argument.

In This Section

TO_CHAR

TO_DATE

TO_TIMESTAMP

TO_NUMBER

Template Patterns for Date/Time Formatting

Template Patterns for Numeric Formatting