My Oracle Support Banner

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

Last updated on FEBRUARY 06, 2020

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.

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


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

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