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

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 hundreds of Community platforms