RDBPROD: How to format a date and time string to include some text
(Doc ID 1168354.1)
Last updated on JANUARY 03, 2019
Applies to:Oracle SQL/Services for Rdb on OpenVMS - Version 7.3 and later
Oracle Rdb Server on OpenVMS - Version 7.1 and later
HP OpenVMS Alpha
HP OpenVMS Itanium
How can I format a date and time value to include some text?
The column referenced is defined as DATE VMS.
ALTER SESSION SET NLS_DATE_FORMAT = 'RRRR-MM-DD\"T\"HH24:MI:SS';
The following error is reported
ERROR: ORA-12705: Cannot access NLS data files or invalid environment specified
This error does not occur with OCI Services 188.8.131.52
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document