TO_CHAR (datetime)
Purpose
This function converts a date, timestamp or interval into a string.
Syntax
to_char (datetime)::=
Usage Notes
- The standard format is used if no format is specified, this is defined in session parameter ALTER SESSION or ALTER SESSION.
- For information, refer to the Date/Time Format Models.
- By the optional third parameter you can specify the language setting for the format (for example, NLS_DATE_LANGUAGE).
- Supported languages are German (DEU, DEUTSCH or GERMAN) and English (ENG, ENGLISH).
- For data type TIMESTAMP WITH LOCAL TIME ZONE this function is calculated within the session time zone.