![]() Previous |
![]() Next |
When you use a DATETIME
value where a text value (TEXT,
NTEXT,
or ID
) is expected, or when you store a DATETIME
value in a text variable, then the DATETIME
value is automatically converted to a text value.
The format of a DATETIME
value is controlled by the NLS_DATE_FORMAT option. Once a DATETIME
value is stored in a text variable, the NLS_DATE_FORMAT setting has no impact.