My Oracle Support Banner

RDBPROD:SQL-F-UNSDATXPR & DATESUBILL Doing Math Operations on DATE VMS Datatypes (Doc ID 69348.1)

Last updated on AUGUST 08, 2016

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.0 to 7.1.5.2 [Release 7.0 to 7.1]
HP OpenVMS VAX
HP OpenVMS Alpha
HP OpenVMS Itanium

Symptoms

You perform a math operation on two DATE VMS datatype fields and receive the following errors:

SQL> SELECT FLD_DATE, FLD_DATE2,
cont> (FLD_DATE2 - FLD_DATE) MONTH FROM MISC_REL;
SQL-F-UNSDATXPR, Unsupported date expression
SQL-F-DATESUBILL, Operands of date/time subtraction are incorrect

Cause

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.