OCIDateTimeCompare()

Purpose

Compares two datetime values.

Syntax

sword OCIDateTimeCompare ( dvoid              *hndl,
                           OCIError           *err,
                           CONST OCIDateTime  *date1, 
                           CONST OCIDateTime  *date2,
                           sword              *result );

Parameters

hndl (IN/OUT)

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().

date1, date2 (IN)

Dates to be compared.

result (OUT)

Comparison result:

Comparison result	Output in result parameter
date1 < date2	-1
date1 = date2	0
date1 > date2	1

Returns

OCI_SUCCESS,

OCI_INVALID_HANDLE, if err is a null pointer,

OCI_ERROR, if an invalid date is used, or if the input date arguments are not of mutually comparable types.

Related Functions

OCIDateTimeConstruct()