TO_DATE
Purpose
This function converts a string into a date.
Syntax
to_date::=
Usage Notes
- If no format is specified, the standard format is used to interpret string, this is defined in session parameter NLS_DATE_FORMAT.
- For information, refer to the Date/time format models.
- ISO formats (
IYYY, IW, ID
) may not be mixed with non-ISO formats. - If single elements are omitted, then their minimum values are assumed (for example,
TO_DATE('1999-12', 'YYYY-MM')
is interpreted as December 1st, 1999). - Session parameter NLS_DATE_FORMAT defines the output of the date.