| Oracle Call Interface Programmer's Guide Release 2 (9.2) Part Number A96584-01  | 
  | 
OCI Datatype Mapping and Manipulation Functions, 20 of 134
Compares two dates.
sword OCIDateCompare ( OCIError *err, CONST OCIDate *date1, CONST OCIDate *date2, sword *result );
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().
Dates to be compared.
Comparison result:
| Comparison result | Output in result parameter | 
|---|---|
|  
 date1 < date2  | 
 
 -1  | 
|  
 date1 = date2  | 
 
 0  | 
|  
 date1 > date2  | 
 
 1  | 
This function returns and error if an invalid date is passed to it.
  | 
![]() Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved.  | 
  |