OCIDateTimeSubtract()

Purpose

Takes two datetimes as input and stores their difference in an interval.

Syntax

sword OCIDateTimeSubtract ( dvoid        *hndl, 
                            OCIError     *err,
                            OCIDateTime  *indate1,
                            OCIDateTime  *indate2, 
                            OCIInterval  *inter );

Parameters

hndl (IN)

The OCI user session handle or environment handle.

err (IN/OUT)

The OCI error handle. If there is an error, it is recorded in err and this function returns OCI_ERROR. Obtain diagnostic information by calling OCIErrorGet().

indate1(IN)

Pointer to the subtrahend.

indate2(IN)

Pointer to the minuend.

inter (OUT)

Pointer to the output interval.

Returns

OCI_SUCCESS if the function completes successfully,

OCI_INVALID_HANDLE if err is null pointer,

OCI_ERROR, if the input datetimes are not of comparable types.

Related Functions

OCIDateTimeCompare()