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.