My Oracle Support Banner

RDBPROD: How to format a date and time string to include some text (Doc ID 1168354.1)

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


Goal

How can I format a date and time value to include some text? 

The column referenced is defined as DATE VMS.

Note: In earlier versions of OCI Services for Rdb this was not possible with OCI (SQL*net connections) using:
              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 7.3.1.1

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.