date & time difference calculation

[Lorry Litman]

Hi,

How to do a date/time difference calculation?

VMS 7.2, PH 7.10G, RDB 7.0
In the RDB database the DATE field is INTEGER and the TIME field is
SMALLINT.
In the dictionary (century included), the DATE field is type D, size 8,
datatype ZU, and the TIME field is type N, size 4, datatype ZU.

A new field is being created, call it DATE_DIFF, I suspect it will be
INTEGER in RDB and Numeric size 10, ZU in the dictionary.
The display of the DATE_DIFF field is to be in the format of YY:MM:DD:HH:MM.

Any help/suggestions would be much appreciated.


Thanx
       Lorry

This e-mail and/or any documents in this transmission is intended for the address(s) only and may contain legally privileged or confidential information. Any unauthorized use, disclosure, distribution, copying or dissemination is strictly prohibited. If you receive this transmission in error, please notify the sender immediately and return the original.