Tochar usage in oracle

The TO_CHAR function converts an Oracle expression into a character value, formatting the output to suit your needs. Use a string template (format_mask) to define the format, including text characters, format modifiers, and placeholders. Format masks are case-sensitive, and placeholders require the correct format modifier.

Usage of TO_CHAR function in Oracle

The role of TO_CHAR function

Syntax

TO_CHAR(expression, format_mask)

Parameters

expression: Any valid Oracle expression to be converted.
• format_mask: A string template that defines the format of character values.

Format Mask

• Text characters:are displayed directly in the output.
• Format modifier:Control how the output value is formatted.
• Placeholder:represents a number or date/time part.

Usage Example

Convert a number to a string in a specific format:

TO_CHAR(12345, '99,999')

Convert date to readable format:

TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')

Use placeholders characters to display numeric and decimal parts:

TO_CHAR(12345.6789, '99,999.99')

Use text characters as delimiters:

TO_CHAR(12345, '99,999$" records"')

Note

The format mask is case-sensitive.
• When using placeholders, the correct format modifier must be specified.
• TO_CHAR function does not modify the original value, it only returns a formatted string representation.

The above is the detailed content of Tochar usage in oracle. For more information, please follow other related articles on the PHP Chinese website!