oracle.sql
Class DATE

java.lang.Object
  |
  +--oracle.sql.Datum
        |
        +--oracle.sql.DATE

public class DATE
extends Datum

DATE Class


The DATE class provides conversions between the Oracle Date (ldx_t) data type and Java classes java.sql.Date, java.sql.Time, java.sql.Timestamp

The internal data for this object is stored as a seven byte array in the super class' storage area. The bytes are arranged as follows:

Byte       Represents
0         Century (19 for 1990)
1         Decade  (90 for 1990)
2         Month
3         Day      
4         Hour
5         Minute
6         Seconds

Static methods are used for conversions.


Field Summary
static int BDA
          Bad day: above range
static int BDAL
          Bad day: below range
static int BDT
          Bad date format
static int BHR
          Bad hour: above range
static int BHRL
          Bad hour: below range
static int BMN
          Bad minute: above range
static int BMNL
          Bad minute: below range
static int BMO
          Bad month: above range
static int BMOL
          Bad month: below range
static int BSC
          Bad second: above range
static int BSCL
          Bad second: below range
static int BYR
          Bad year: above range
static int BYRL
          Bad year: below range
static int HRZER0
          Zero valued hour
static int MIZERO
          Zero valued minute
static int MSD
          Day is one of those "missing" from the year 1582
static int SEZERO
          Zero valued second
static int YR0
          Year zero does not exist
 
Constructor Summary
DATE()
          Constructs a DATE object initialized to 1/1/1970.
DATE(byte[] date)
          Create a DATE object represented by the given Oracle Date.
DATE(java.sql.Date date)
          Create a DATE object given a Java Date object.
DATE(java.sql.Date date, java.util.Calendar cal)
          Create a DATE object given a Java Date object and a Calendar
DATE(java.lang.Object obj)
          Constructs a DATE object initialized to the value specified by the object
DATE(java.lang.Object obj, java.util.Calendar cal)
          Constructs a DATE object initialized to the value specified by the object and a Calendar
DATE(java.lang.String str)
          Create a DATE object given a Java String object.
DATE(java.lang.String str, java.util.Calendar cal)
          Create a DATE object given a Java String object and a Calendar
DATE(java.sql.Time time)
          Create a DATE object given a Java Time object.
DATE(java.sql.Time time, java.util.Calendar cal)
          Create a DATE object given a Java Time object and a Calendar
DATE(java.sql.Timestamp timestamp)
          Create a DATE object given a Java Timestamp object
DATE(java.sql.Timestamp timestamp, java.util.Calendar cal)
          Create a DATE object given a Java Timestamp object and a Calendar
 
Method Summary
 DATE addJulianDays(int julianDay, int julianSec)
          Add Julian days to a date.
 DATE addMonths(int months)
          Add months to a date.
static int checkValidity(byte[] date)
          Checks the DATE passed in.
 int compareTo(DATE date)
          Returns -1 if DATE is less than date, 0 if DATE and date are equal (==), 1 if DATE is greater than date.
 java.sql.Date dateValue()
          Calls toDate to convert internal Oracle Date to a Java Date.
 java.sql.Date dateValue(java.util.Calendar cal)
          Calls toDate to convert internal Oracle Date and Calendar to a Java Date.
 void diffInJulianDays(DATE date, int[] julianDay, int[] julianSec)
          Calculates the difference between two dates in Julian days.
 NUMBER diffInMonths(DATE date)
          Calculates the difference between two dates in months.
static DATE fromJulianDays(int julianDay, int julianSec)
          Convert given julian days and seconds to an Oracle Date.
static DATE fromText(java.lang.String datestr, java.lang.String fmt, java.lang.String lang)
          Convert a string to a DATE object.
static DATE getCurrentDate()
          Gets current date and time
 boolean isConvertibleTo(java.lang.Class cls)
          Determines if the object can be converted to a particular class
 DATE lastDayOfMonth()
          returns a DATE object intialized to the last day of the month .
 java.lang.Object makeJdbcArray(int arraySize)
          Returns a JDBC array representation of the datum
static void numberToJulianDays(NUMBER num, int[] julianDay, int[] julianSec)
          Converts an Oracle Number to julian days and seconds
static byte[] parseFormat(java.lang.String fmt, java.lang.String lang)
          Converts the fmt string into tokens for use by toText().
 DATE round(java.lang.String prec)
          returns a DATE object with date rounded to specified precision
 DATE setDayOfWeek(int day)
          returns a DATE object initialized to date advanced to the week of the day specified.
 java.lang.String stringValue()
          Calls toString to convert internal Oracle Date to a Java String.
 java.sql.Timestamp timestampValue()
          Calls toTimestamp to convert internal Oracle Date to a Java Timestamp.
 java.sql.Timestamp timestampValue(java.util.Calendar cal)
          Calls toTimestamp to convert internal Oracle Date and Calendar to a Java Timestamp.
 java.sql.Time timeValue()
          Calls toTime to convert internal Oracle Date to a Java Time.
 java.sql.Time timeValue(java.util.Calendar cal)
          Calls toTime to convert internal Oracle Date and Calendar to a Java Time.
 byte[] toBytes()
           
static byte[] toBytes(java.sql.Date date)
          Convert Java Date to Oracle Date.
static byte[] toBytes(java.sql.Date date, java.util.Calendar cal)
          Convert Java Date and Calendar to Oracle Date.
static byte[] toBytes(java.lang.String str)
          Convert Java String to Oracle Date.
static byte[] toBytes(java.lang.String str, java.util.Calendar cal)
          Convert Java String to Oracle Date.
static byte[] toBytes(java.sql.Time time)
          Convert Java Time to Oracle Date.
static byte[] toBytes(java.sql.Time time, java.util.Calendar cal)
          Convert Java Time and Calendar to Oracle Date.
static byte[] toBytes(java.sql.Timestamp timestamp)
          Convert Java Timestamp to Oracle Date.
static byte[] toBytes(java.sql.Timestamp timestamp, java.util.Calendar cal)
          Convert Java Timestamp and Calendar to Oracle Date.
static java.sql.Date toDate(byte[] date)
          Convert Oracle Date to Java Date.
static java.sql.Date toDate(byte[] date, java.util.Calendar cal)
          Convert Oracle Date and Calendar to Java Date.
 java.lang.Object toJdbc()
          Returns the JDBC representation of the datum object
 void toJulianDays(int[] julianDay, int[] julianSec)
          Convert to julian days and seconds from the given date.
 NUMBER toNumber()
          Converts date to an Oracle Number.
static java.lang.String toString(byte[] date)
          Converts a date to a string
 java.lang.String toText(byte[] pfmt, java.lang.String lang)
          Convert date to text as specified by fmt.
 java.lang.String toText(java.lang.String fmt, java.lang.String lang)
          Convert date to text as specified by fmt.
static java.sql.Time toTime(byte[] date)
          Convert Oracle Date to Java Time.
static java.sql.Time toTime(byte[] date, java.util.Calendar cal)
          Convert Oracle Date and Calendar to Java Time.
static java.sql.Timestamp toTimestamp(byte[] date)
          Convert Oracle Date to Java Timestamp.
static java.sql.Timestamp toTimestamp(byte[] date, java.util.Calendar cal)
          Convert Oracle Date and Calendar to Java Timestamp.
 DATE truncate(java.lang.String prec)
          returns a DATE object with date truncated to specified precision
 
Methods inherited from class oracle.sql.Datum
asciiStreamValue, bigDecimalValue, binaryStreamValue, booleanValue, byteValue, characterStreamValue, doubleValue, equals, floatValue, getBytes, getLength, getStream, intValue, longValue, setBytes, setShareBytes, shareBytes
 
Methods inherited from class java.lang.Object
getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

BDA

public static final int BDA
Bad day: above range

BDAL

public static final int BDAL
Bad day: below range

BMO

public static final int BMO
Bad month: above range

BMOL

public static final int BMOL
Bad month: below range

BYR

public static final int BYR
Bad year: above range

BYRL

public static final int BYRL
Bad year: below range

BHR

public static final int BHR
Bad hour: above range

BHRL

public static final int BHRL
Bad hour: below range

BMN

public static final int BMN
Bad minute: above range

BMNL

public static final int BMNL
Bad minute: below range

BSC

public static final int BSC
Bad second: above range

BSCL

public static final int BSCL
Bad second: below range

MSD

public static final int MSD
Day is one of those "missing" from the year 1582

YR0

public static final int YR0
Year zero does not exist

BDT

public static final int BDT
Bad date format

HRZER0

public static final int HRZER0
Zero valued hour

MIZERO

public static final int MIZERO
Zero valued minute

SEZERO

public static final int SEZERO
Zero valued second
Constructor Detail

DATE

public DATE()
Constructs a DATE object initialized to 1/1/1970.

DATE

public DATE(byte[] date)
Create a DATE object represented by the given Oracle Date.
Parameters:
date - Oracle Date

DATE

public DATE(java.sql.Date date)
Create a DATE object given a Java Date object.
Parameters:
date - Java Date object

DATE

public DATE(java.sql.Time time)
Create a DATE object given a Java Time object.
Parameters:
time - Java Time object

DATE

public DATE(java.sql.Timestamp timestamp)
Create a DATE object given a Java Timestamp object
Parameters:
timestamp - Java Timestamp object

DATE

public DATE(java.sql.Date date,
            java.util.Calendar cal)
Create a DATE object given a Java Date object and a Calendar
Parameters:
date - Java Date object
cal - Java Calendar object which encapsulates the timezone information of date

DATE

public DATE(java.sql.Time time,
            java.util.Calendar cal)
Create a DATE object given a Java Time object and a Calendar
Parameters:
time - Java Time object
cal - Java Calendar object which encapsulates the timezone information of time

DATE

public DATE(java.sql.Timestamp timestamp,
            java.util.Calendar cal)
Create a DATE object given a Java Timestamp object and a Calendar
Parameters:
timestamp - Java Timestamp object
cal - Java Calendar object which encapsulates the timezone information of timestamp

DATE

public DATE(java.lang.String str)
Create a DATE object given a Java String object.
Parameters:
str - Java String object

DATE

public DATE(java.lang.String str,
            java.util.Calendar cal)
Create a DATE object given a Java String object and a Calendar
Parameters:
str - Java String object
cal - Java Calendar object which encapsulates the timezone information for interpreting str

DATE

public DATE(java.lang.Object obj)
     throws java.sql.SQLException
Constructs a DATE object initialized to the value specified by the object
Parameters:
obj - Object value
obj - Object value
obj - Object value
Throws:
java.sql.SQLException - if initialization is not allowed

DATE

public DATE(java.lang.Object obj,
            java.util.Calendar cal)
     throws java.sql.SQLException
Constructs a DATE object initialized to the value specified by the object and a Calendar
Parameters:
obj - Object value
cal - Calendar to use
obj - Object value
obj - Object value
cal - Calendar which encapsulates the timezone information of obj
Throws:
java.sql.SQLException - if initialization is not allowed
Method Detail

toDate

public static java.sql.Date toDate(byte[] date)
Convert Oracle Date to Java Date.
Parameters:
date - Oracle Date to be converted
Returns:
the java.sql.Date object represented by the Oracle Date date.

toTime

public static java.sql.Time toTime(byte[] date)
Convert Oracle Date to Java Time.
Parameters:
date - Oracle Date to be converted
Returns:
the java.sql.Time object represented by the Oracle Date date.

toTimestamp

public static java.sql.Timestamp toTimestamp(byte[] date)
Convert Oracle Date to Java Timestamp.
Parameters:
date - Oracle Date to be converted
Returns:
the java.sql.Timestamp object represented by the Oracle Date date.

toDate

public static java.sql.Date toDate(byte[] date,
                                   java.util.Calendar cal)
Convert Oracle Date and Calendar to Java Date.
Parameters:
date - Oracle Date to be converted
cal - Calendar which encapsulates the timezone information to be used to create Date object
Returns:
the java.sql.Date object represented by the Oracle Date date.

toTime

public static java.sql.Time toTime(byte[] date,
                                   java.util.Calendar cal)
Convert Oracle Date and Calendar to Java Time.
Parameters:
date - Oracle Date to be converted
cal - Calendar which encapsulates the timezone information to be used to create the Time object
Returns:
the java.sql.Time object represented by the Oracle Date date.

toTimestamp

public static java.sql.Timestamp toTimestamp(byte[] date,
                                             java.util.Calendar cal)
Convert Oracle Date and Calendar to Java Timestamp.
Parameters:
date - Oracle Date to be converted
cal - Calendar which encapsulates the timezone information to be used to create the Timestamp object
Returns:
the java.sql.Timestamp object represented by the Oracle Date date.

toString

public static java.lang.String toString(byte[] date)
Converts a date to a string
Parameters:
date - a byte array
Returns:
String representing the date

toBytes

public byte[] toBytes()

toBytes

public static byte[] toBytes(java.sql.Date date)
Convert Java Date to Oracle Date.
Parameters:
date - java.sql.Date object to be converted.
Returns:
the byte array representing the input date.

toBytes

public static byte[] toBytes(java.sql.Time time)
Convert Java Time to Oracle Date.
Parameters:
time - java.sql.Time object to be converted.
Returns:
the byte array representing the input time.

toBytes

public static byte[] toBytes(java.sql.Timestamp timestamp)
Convert Java Timestamp to Oracle Date.
Parameters:
timestamp - java.sql.Timestamp object to be converted.
Returns:
the byte array representing the input timestamp.

toBytes

public static byte[] toBytes(java.sql.Date date,
                             java.util.Calendar cal)
Convert Java Date and Calendar to Oracle Date.
Parameters:
date - java.sql.Date object to be converted.
cal - java.util.Calendar object which encapsulates the timezone information of date
Returns:
the byte array representing the input date.

toBytes

public static byte[] toBytes(java.sql.Time time,
                             java.util.Calendar cal)
Convert Java Time and Calendar to Oracle Date.
Parameters:
time - java.sql.Time object to be converted.
cal - java.util.Calendar object which encapsulates the timezone information of time
Returns:
the byte array representing the input time.

toBytes

public static byte[] toBytes(java.sql.Timestamp timestamp,
                             java.util.Calendar cal)
Convert Java Timestamp and Calendar to Oracle Date.
Parameters:
timestamp - java.sql.Timestamp object to be converted.
cal - java.util.Calendar object which encapsulates the timezone information of date
Returns:
the byte array representing the input timestamp.

toBytes

public static byte[] toBytes(java.lang.String str)
Convert Java String to Oracle Date.
Parameters:
str - java.lang.String object to be converted.
Returns:
the byte array representing the input string.

toBytes

public static byte[] toBytes(java.lang.String str,
                             java.util.Calendar cal)
Convert Java String to Oracle Date.
Parameters:
str - java.lang.String object to be converted.
cal - java.util.Calendar object which encapsulates the timezone information for interpreting str
Returns:
the byte array representing the input string.

dateValue

public java.sql.Date dateValue()
Calls toDate to convert internal Oracle Date to a Java Date.
Returns:
a Java Date value
Overrides:
dateValue in class Datum

timeValue

public java.sql.Time timeValue()
Calls toTime to convert internal Oracle Date to a Java Time.
Returns:
a Java Time value
Overrides:
timeValue in class Datum

timestampValue

public java.sql.Timestamp timestampValue()
Calls toTimestamp to convert internal Oracle Date to a Java Timestamp.
Returns:
a Java Timestamp value
Overrides:
timestampValue in class Datum

dateValue

public java.sql.Date dateValue(java.util.Calendar cal)
Calls toDate to convert internal Oracle Date and Calendar to a Java Date.
Parameters:
cal - Calendar to use
Returns:
a Java Date value

timeValue

public java.sql.Time timeValue(java.util.Calendar cal)
Calls toTime to convert internal Oracle Date and Calendar to a Java Time.
Parameters:
cal - Calendar to use
Returns:
a Java Time value

timestampValue

public java.sql.Timestamp timestampValue(java.util.Calendar cal)
Calls toTimestamp to convert internal Oracle Date and Calendar to a Java Timestamp.
Parameters:
cal - Calendar to use
Returns:
a Java Timestamp value

stringValue

public java.lang.String stringValue()
Calls toString to convert internal Oracle Date to a Java String.
Returns:
a Java String value
Overrides:
stringValue in class Datum

toJdbc

public java.lang.Object toJdbc()
Returns the JDBC representation of the datum object
Returns:
an object containing the JDBC value
Overrides:
toJdbc in class Datum

makeJdbcArray

public java.lang.Object makeJdbcArray(int arraySize)
Returns a JDBC array representation of the datum
Parameters:
arraySize - size of the array
Returns:
an object containing the JDBC array value
Overrides:
makeJdbcArray in class Datum

isConvertibleTo

public boolean isConvertibleTo(java.lang.Class cls)
Determines if the object can be converted to a particular class
Parameters:
cls - Class to convert to
Returns:
true, if conversion to cls is permitted false, if conversion to cls is not permitted
Overrides:
isConvertibleTo in class Datum

addJulianDays

public DATE addJulianDays(int julianDay,
                          int julianSec)
                   throws java.sql.SQLException
Add Julian days to a date.
Parameters:
julianDay - Number of Julian days to add to DATE
julianSec - Number of seconds past midnight
Returns:
new DATE object initalized to the DATE values added to the Julian days.
Throws:
java.sql.SQLException - if Java implementation is not available

addMonths

public DATE addMonths(int months)
               throws java.sql.SQLException
Add months to a date.
Parameters:
months - integral months to add to date
Returns:
new DATE object initialized to the DATE value added to months. months can be negative to perform month subtraction.
Throws:
java.sql.SQLException - if Java implementation is not available

diffInJulianDays

public void diffInJulianDays(DATE date,
                             int[] julianDay,
                             int[] julianSec)
                      throws java.sql.SQLException
Calculates the difference between two dates in Julian days.
Parameters:
date - Date to be subtracted.
julianDay - Number of Julian days
julianSec - Number of seconds past midnight
Throws:
java.sql.SQLException - if Java implementation is not available

diffInMonths

public NUMBER diffInMonths(DATE date)
                    throws java.sql.SQLException
Calculates the difference between two dates in months.
Parameters:
date - Date to be subtracted.
Returns:
NUMBER difference in months as an Oracle Number.
Throws:
java.sql.SQLException - if Java implementation is not available

getCurrentDate

public static DATE getCurrentDate()
                           throws java.sql.SQLException
Gets current date and time
Returns:
DATE object
Throws:
java.sql.SQLException - if Java implementation is not available

checkValidity

public static int checkValidity(byte[] date)
                         throws java.sql.SQLException
Checks the DATE passed in.
Parameters:
date - Date to be checked
Returns:
0 if the date is valid or the ORed representations in the following table:
BDA Bad day: above range
BDAL Bad day: below range
BMO Bad month: above range
BMOL Bad month: below range
BYR Bad year: above range
BYRL Bad year: below range
BHR Bad hour: above range
BHRL Bad hour: below range
BMN Bad minute: above range
BMNL Bad minute: below range
BSC Bad second: above range
BSCL Bad second: below range
MSD Day is one of those "missing" from the year 1582
YR0 Year zero does not exist
BDT Bad date format
HRZERO Zero valued hour
MIZERO Zero valued minute
SEZERO Zero valued second
Throws:
java.sql.SQLException - if Java implementation is not available

fromJulianDays

public static DATE fromJulianDays(int julianDay,
                                  int julianSec)
                           throws java.sql.SQLException
Convert given julian days and seconds to an Oracle Date.
Parameters:
julianDay - Number of Julian days
julianSec - Number of seconds past midnight
Returns:
new DATE object initialized based on the number of Julian days.
Throws:
java.sql.SQLException - if Java implementation is not available

fromText

public static DATE fromText(java.lang.String datestr,
                            java.lang.String fmt,
                            java.lang.String lang)
                     throws java.sql.SQLException
Convert a string to a DATE object.
Parameters:
datestr - Input Date string
fmt - Date Format
lang - Input date language
Returns:
DATE object Note: Some of the extended Date Formats supported by the C Date libraries from CORE are not supported in this pure Java equivalent implementation. The Format strings supported are:
String Meaning
a.d. B.C./A.D. indicator
a.m. A.M./P.M. indicator
ad BC/AD indicator
am AM/PM indicator
b.c. B.C./A.D. indicator
bc BC/AD indicator
d day of the week
day name of the day, spelled out
dd day of the month
ddd day of year
dy name of weekday abbreviated
hh hour representation in 12 hour format
hh24 hour representation in 24 hour format
mi minutes
mm two digit month representation
mon month abbreviation
month name of the month, spelled out
p.m. A.M./P.M. indicator
pm AM/PM indicator
ss two digit second representation
Y last digit of the year
YY last two digits of a year
YYY last three digits of a year
YYYY year
"" all text in quotes is copied into the output string It is not possible to place a quote character into the output string. On input, literal text is a placeholder for another string of the same length
/,%&@#.. punctuation (non-alphanumeric characters) is treated exactly like a literal without the need for quotes.

The Date format string not supported versus the C library are:

String Meaning
E abbreviated era name
EE full era name
FX all date literals must be an exact match
j Julian day
RM Roman numeral month (I-XII)
RR Round year with two digits (on input, rounds the century up one if the year is <50 and the reference date is >= 50, and down one century if the year is >= 50 and the reference date is <50)
RRRR Round year (on input, accepts either four digit input or, for two digit input, rounds the century up one if the year is <50 and the reference date is >= 50, and down one century if the year is >= 50 and the reference date is <50)
sssss number of seconds past midnight
sy,yyy signed year (BC dates have "-" in front)
syYYY signed year (BC dates have "-" in front)
Y,YYY year with comma
YEAR year number spelled out

Also parsing is strict i.e. spaces and literals should match the format string exactly. (except for a.d./b.c. the string should be ad/bc)


lastDayOfMonth

public DATE lastDayOfMonth()
                    throws java.sql.SQLException
returns a DATE object intialized to the last day of the month .
Returns:
a DATE object
Throws:
java.sql.SQLException - if Java implementation is not available

numberToJulianDays

public static void numberToJulianDays(NUMBER num,
                                      int[] julianDay,
                                      int[] julianSec)
                               throws java.sql.SQLException
Converts an Oracle Number to julian days and seconds
Parameters:
num - Oracle Number to convert
julianDay - Number of Julian days
julianSec - Number of seconds past midnight
Throws:
java.sql.SQLException - if Java implementation is not available

round

public DATE round(java.lang.String prec)
           throws java.sql.SQLException
returns a DATE object with date rounded to specified precision
Parameters:
prec - precision to use while rounding
Returns:
DATE object
Throws:
java.sql.SQLException - if Java implementation is not available

setDayOfWeek

public DATE setDayOfWeek(int day)
                  throws java.sql.SQLException
returns a DATE object initialized to date advanced to the week of the day specified.
Parameters:
day - day of the week the date needs to be advanced
Returns:
DATE object.
Throws:
java.sql.SQLException - if Java implementation is not available

toJulianDays

public void toJulianDays(int[] julianDay,
                         int[] julianSec)
                  throws java.sql.SQLException
Convert to julian days and seconds from the given date.
Parameters:
julianDay - Number of Julian days
julianSec - Number of seconds past midnight
Returns:
the Julian Date of the DATE object
Throws:
java.sql.SQLException - if Java implementation is not available

toNumber

public NUMBER toNumber()
                throws java.sql.SQLException
Converts date to an Oracle Number.
Returns:
an Oracle Number
Throws:
java.sql.SQLException - if Java implementation is not available

toText

public java.lang.String toText(java.lang.String fmt,
                               java.lang.String lang)
                        throws java.sql.SQLException
Convert date to text as specified by fmt.
Parameters:
fmt - date format
lang - the NLS language the conversion is to be performed in, null indicates use default.
Returns:
a String converted from date via format fmt.
Throws:
java.sql.SQLException - if Java implementation is not available or an invalid format string is provided.

toText

public java.lang.String toText(byte[] pfmt,
                               java.lang.String lang)
                        throws java.sql.SQLException
Convert date to text as specified by fmt.
Parameters:
pfmt - date format parsed by parseFormat
lang - the NLS language the conversion is to be performed in, null indicates use default.
Returns:
a String converted from date via format fmt.
Throws:
java.sql.SQLException - if Java implementation is not available or an invalid format string is provided.

parseFormat

public static byte[] parseFormat(java.lang.String fmt,
                                 java.lang.String lang)
                          throws java.sql.SQLException
Converts the fmt string into tokens for use by toText().
Parameters:
fmt - date format
lang - A String containing NLS Language and/or Territory null indicates to use default.
Returns:
a byte array containing tokens from the parsed format
Throws:
java.sql.SQLException - if the format string can not be parsed.

truncate

public DATE truncate(java.lang.String prec)
              throws java.sql.SQLException
returns a DATE object with date truncated to specified precision
Parameters:
prec - precision to use while truncating
Returns:
DATE object
Throws:
java.sql.SQLException - if Java implementation is not available

compareTo

public int compareTo(DATE date)
Returns -1 if DATE is less than date, 0 if DATE and date are equal (==), 1 if DATE is greater than date.
Parameters:
date - input Oracle Date
Returns:
integer result of comparison