RDBPROD: How to format a date and time string to include some text
Last updated on AUGUST 09, 2016
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 220.127.116.11
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms