## Uses of Class
oracle.sql.DATE

Packages that use DATE
oracle.jdbc: Beginning in Oracle9i, the Oracle extensions to JDBC are captured in the package `oracle.jdbc`.
oracle.sql: A package of classes that represent java SQL types and Oracle specific SQL types.
oracle.sql.json: The API for JSON type in Oracle Database.

### Uses of DATE in oracle.jdbc

Methods in oracle.jdbc that return DATE
`DATE` OracleConnection.`createDATE(Date value)` Creates a DATE that has the given value.
`DATE` OracleConnectionWrapper.`createDATE(Date value)` Creates a DATE that has the given value.
`DATE` OracleConnectionWrapper.`createDATE(Date value)` Creates a DATE that has the given value.
`DATE` OracleConnection.`createDATE(Date value)` Creates a DATE that has the given value.
`DATE` OracleConnection.`createDATE(Date value, Calendar cal)` Creates a DATE that has the given value.
`DATE` OracleConnectionWrapper.`createDATE(Date value, Calendar cal)` Creates a DATE that has the given value.
`DATE` OracleConnectionWrapper.`createDATE(Date value, Calendar cal)` Creates a DATE that has the given value.
`DATE` OracleConnection.`createDATE(Date value, Calendar cal)` Creates a DATE that has the given value.
`DATE` OracleConnection.`createDATE(String value)` Creates a DATE that has the given value.
`DATE` OracleConnectionWrapper.`createDATE(String value)` Creates a DATE that has the given value.
`DATE` OracleConnectionWrapper.`createDATE(String value)` Creates a DATE that has the given value.
`DATE` OracleConnection.`createDATE(String value)` Creates a DATE that has the given value.
`DATE` OracleConnection.`createDATE(Time value)` Creates a DATE that has the given value.
`DATE` OracleConnectionWrapper.`createDATE(Time value)` Creates a DATE that has the given value.
`DATE` OracleConnectionWrapper.`createDATE(Time value)` Creates a DATE that has the given value.
`DATE` OracleConnection.`createDATE(Time value)` Creates a DATE that has the given value.
`DATE` OracleConnection.`createDATE(Time value, Calendar cal)` Creates a DATE that has the given value.
`DATE` OracleConnectionWrapper.`createDATE(Time value, Calendar cal)` Creates a DATE that has the given value.
`DATE` OracleConnectionWrapper.`createDATE(Time value, Calendar cal)` Creates a DATE that has the given value.
`DATE` OracleConnection.`createDATE(Time value, Calendar cal)` Creates a DATE that has the given value.
`DATE` OracleConnection.`createDATE(Timestamp value)` Creates a DATE that has the given value.
`DATE` OracleConnectionWrapper.`createDATE(Timestamp value)` Creates a DATE that has the given value.
`DATE` OracleConnectionWrapper.`createDATE(Timestamp value)` Creates a DATE that has the given value.
`DATE` OracleConnection.`createDATE(Timestamp value)` Creates a DATE that has the given value.
`DATE` OracleConnection.`createDATE(Timestamp value, Calendar cal)` Creates a DATE that has the given value.
`DATE` OracleConnectionWrapper.`createDATE(Timestamp value, Calendar cal)` Creates a DATE that has the given value.
`DATE` OracleConnectionWrapper.`createDATE(Timestamp value, Calendar cal)` Creates a DATE that has the given value.
`DATE` OracleConnection.`createDATE(Timestamp value, Calendar cal)` Creates a DATE that has the given value.
`DATE` OracleCallableStatement.`getDATE(int parameterIndex)` Retrieves data into an `oracle.sql.DATE` object.
`DATE` OracleResultSet.`getDATE(int columnIndex)` Oracle extension.
`DATE` OracleResultSet.`getDATE(int columnIndex)` Oracle extension.
`DATE` OracleCallableStatement.`getDATE(int parameterIndex)` Retrieves data into an `oracle.sql.DATE` object.
`DATE` OracleResultSet.`getDATE(String columnName)` Oracle extension.
`DATE` OracleResultSet.`getDATE(String columnName)` Oracle extension.

Methods in oracle.jdbc with parameters of type DATE
`TIMESTAMP` OracleConnection.`createTIMESTAMP(DATE value)` Creates a new TIMESTAMP with the given value.
`TIMESTAMP` OracleConnectionWrapper.`createTIMESTAMP(DATE value)` Creates a new TIMESTAMP with the given value.
`TIMESTAMP` OracleConnectionWrapper.`createTIMESTAMP(DATE value)` Creates a new TIMESTAMP with the given value.
`TIMESTAMP` OracleConnection.`createTIMESTAMP(DATE value)` Creates a new TIMESTAMP with the given value.
`TIMESTAMPLTZ` OracleConnection.`createTIMESTAMPLTZ(DATE value, Calendar cal)` Creates a new TIMESTAMPLTZ with the given value.
`TIMESTAMPLTZ` OracleConnectionWrapper.`createTIMESTAMPLTZ(DATE value, Calendar cal)` Creates a new TIMESTAMPLTZ with the given value.
`TIMESTAMPLTZ` OracleConnectionWrapper.`createTIMESTAMPLTZ(DATE value, Calendar cal)` Creates a new TIMESTAMPLTZ with the given value.
`TIMESTAMPLTZ` OracleConnection.`createTIMESTAMPLTZ(DATE value, Calendar cal)` Creates a new TIMESTAMPLTZ with the given value.
`TIMESTAMPTZ` OracleConnection.`createTIMESTAMPTZ(DATE value)`
`TIMESTAMPTZ` OracleConnectionWrapper.`createTIMESTAMPTZ(DATE value)`
`TIMESTAMPTZ` OracleConnectionWrapper.`createTIMESTAMPTZ(DATE value)`
`TIMESTAMPTZ` OracleConnection.`createTIMESTAMPTZ(DATE value)`
`void` OraclePreparedStatement.`setDATE(int parameterIndex, DATE date)` Binds the designated parameter to a `oracle.sql.DATE` value.
`void` OraclePreparedStatement.`setDATE(int parameterIndex, DATE date)` Binds the designated parameter to a `oracle.sql.DATE` value.
`void` OracleCallableStatement.`setDATE(String parameterName, DATE x)` Sets the designated parameter to an `oracle.sql.DATE`value.
`void` OracleCallableStatement.`setDATE(String parameterName, DATE x)` Sets the designated parameter to an `oracle.sql.DATE`value.
`void` OraclePreparedStatement.`setDATEAtName(String parameterName, DATE value)` Sets the designated parameter to an oracle.sql.DATE value.
`void` OraclePreparedStatement.`setDATEAtName(String parameterName, DATE value)` Sets the designated parameter to an oracle.sql.DATE value.
`void` OracleResultSet.`updateDATE(int columnIndex, DATE value)` Oracle extension.
`void` OracleResultSet.`updateDATE(int columnIndex, DATE value)` Oracle extension.
`void` OracleResultSet.`updateDATE(String columnName, DATE value)` Oracle extension.
`void` OracleResultSet.`updateDATE(String columnName, DATE value)` Oracle extension.

### Uses of DATE in oracle.sql

Methods in oracle.sql that return DATE
`DATE` DATE.`addJulianDays(int julianDay, int julianSec)` Add Julian days to a date.
`DATE` DATE.`addJulianDays(int julianDay, int julianSec)` Add Julian days to a date.
`DATE` DATE.`addMonths(int months)` Add months to a date.
`DATE` DATE.`addMonths(int months)` Add months to a date.
`static DATE` DATE.`fromJulianDays(int julianDay, int julianSec)` Convert given julian days and seconds to an Oracle Date.
`static DATE` DATE.`fromJulianDays(int julianDay, int julianSec)` Convert given julian days and seconds to an Oracle Date.
`static DATE` DATE.`fromText(String datestr, String fmt, String lang)` Convert a string to a DATE object.
`static DATE` DATE.`fromText(String datestr, String fmt, String lang)` Convert a string to a DATE object.
`static DATE` DATE.`getCurrentDate()` Gets current date and time
`static DATE` DATE.`getCurrentDate()` Gets current date and time
`DATE` DATE.`lastDayOfMonth()` returns a DATE object intialized to the last day of the month .
`DATE` DATE.`lastDayOfMonth()` returns a DATE object intialized to the last day of the month .
`static DATE` DATE.`of(java.time.LocalDate ld)` Creates DATE from the LocalDate.
`static DATE` DATE.`of(java.time.LocalDate ld)` Creates DATE from the LocalDate.
`static DATE` DATE.`of(java.time.LocalDateTime ldt)` Creates DATE from the LocalDateTime.
`static DATE` DATE.`of(java.time.LocalDateTime ldt)` Creates DATE from the LocalDateTime.
`static DATE` DATE.`of(java.time.LocalTime lt)` Creates DATE from the LocalTime.
`static DATE` DATE.`of(java.time.LocalTime lt)` Creates DATE from the LocalTime.
`DATE` DATE.`round(String prec)` returns a DATE object with date rounded to specified precision
`DATE` DATE.`round(String prec)` returns a DATE object with date rounded to specified precision
`DATE` DATE.`setDayOfWeek(int day)` returns a DATE object initialized to date advanced to the week of the day specified.
`DATE` DATE.`setDayOfWeek(int day)` returns a DATE object initialized to date advanced to the week of the day specified.
`static DATE` TIMESTAMP.`toDATE(byte[] timestamp)` Convert a byte array representing a TIMESTAMP object to a Oracle DATE Object
`static DATE` TIMESTAMP.`toDATE(byte[] timestamp)` Convert a byte array representing a TIMESTAMP object to a Oracle DATE Object
`static DATE` TIMESTAMPLTZ.`toDATE(Connection conn, byte[] timestampltz)` Convert a byte array representing a TIMESTAMPLTZ object to a Oracle DATE Object
`static DATE` TIMESTAMPTZ.`toDATE(Connection conn, byte[] timestamptz)` Convert a byte array representing a TIMESTAMPTZ object to a Oracle DATE Object
`static DATE` TIMESTAMPTZ.`toDATE(Connection conn, byte[] timestamptz)` Convert a byte array representing a TIMESTAMPTZ object to a Oracle DATE Object
`static DATE` TIMESTAMPLTZ.`toDATE(Connection conn, byte[] timestampltz)` Convert a byte array representing a TIMESTAMPLTZ object to a Oracle DATE Object
`static DATE` TIMESTAMPLTZ.`toDATE(Connection conn, byte[] timestampltz, Calendar dbtz)` Deprecated.
`static DATE` TIMESTAMPLTZ.`toDATE(Connection conn, byte[] timestampltz, Calendar dbtz)` Deprecated.
`DATE` DATE.`truncate(String prec)` returns a DATE object with date truncated to specified precision
`DATE` DATE.`truncate(String prec)` returns a DATE object with date truncated to specified precision
`DATE` DATE.`zeroTime()` Zero out the time from a DATE object.
`DATE` DATE.`zeroTime()` Zero out the time from a DATE object.

Methods in oracle.sql with parameters of type DATE
`int` DATE.`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.
`int` DATE.`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.
`void` DATE.`diffInJulianDays(DATE date, int[] julianDay, int[] julianSec)` Calculates the difference between two dates in Julian days.
`void` DATE.`diffInJulianDays(DATE date, int[] julianDay, int[] julianSec)` Calculates the difference between two dates in Julian days.
`NUMBER` DATE.`diffInMonths(DATE date)` Calculates the difference between two dates in months.
`NUMBER` DATE.`diffInMonths(DATE date)` Calculates the difference between two dates in months.
`static byte[]` TIMESTAMPLTZ.`toBytes(Connection conn, Calendar cal, DATE date)` Convert Oracle DATE to Oracle TIMESTAMPLTZ
`static byte[]` TIMESTAMPLTZ.`toBytes(Connection conn, Calendar cal, DATE date)` Convert Oracle DATE to Oracle TIMESTAMPLTZ
`static byte[]` TIMESTAMPTZ.`toBytes(Connection conn, DATE date)` Convert Oracle DATE to Oracle TIMESTAMPTZ
`static byte[]` TIMESTAMPTZ.`toBytes(Connection conn, DATE date)` Convert Oracle DATE to Oracle TIMESTAMPTZ
`static byte[]` TIMESTAMPLTZ.`toBytes(Connection conn, DATE date, Calendar dbtz)` Deprecated.
`static byte[]` TIMESTAMPLTZ.`toBytes(Connection conn, DATE date, Calendar dbtz)` Deprecated.
`static byte[]` TIMESTAMP.`toBytes(DATE date)` Convert Oracle DATE to Oracle TIMESTAMP
`static byte[]` TIMESTAMP.`toBytes(DATE date)` Convert Oracle DATE to Oracle TIMESTAMP

Constructors in oracle.sql with parameters of type DATE
Constructor and Description
`TIMESTAMP(DATE date)` Create an Oracle TIMESTAMP object represented by the Oracle DATE
`TIMESTAMP(DATE date)` Create an Oracle TIMESTAMP object represented by the Oracle DATE
`TIMESTAMPLTZ(Connection conn, Calendar sess, DATE date)` Create an Oracle TIMESTAMPLTZ object represented by the Oracle DATE
`TIMESTAMPLTZ(Connection conn, Calendar sess, DATE date)` Create an Oracle TIMESTAMPLTZ object represented by the Oracle DATE
`TIMESTAMPLTZ(Connection conn, DATE date)` Create an Oracle TIMESTAMPLTZ object represented by the Oracle DATE
`TIMESTAMPLTZ(Connection conn, DATE date)` Create an Oracle TIMESTAMPLTZ object represented by the Oracle DATE
`TIMESTAMPLTZ(Connection conn, DATE date, Calendar dbtz)` Deprecated.
`TIMESTAMPLTZ(Connection conn, DATE date, Calendar dbtz)` Deprecated.
`TIMESTAMPTZ(Connection conn, DATE date)` Create an Oracle TIMESTAMPTZ object represented by the Oracle DATE
`TIMESTAMPTZ(Connection conn, DATE date)` Create an Oracle TIMESTAMPTZ object represented by the Oracle DATE

### Uses of DATE in oracle.sql.json

Methods in oracle.sql.json that return DATE
`DATE` OracleJsonDate.`getDATE()` Returns this value as a SQL `DATE`.
`DATE` OracleJsonDate.`getDATE()` Returns this value as a SQL `DATE`.

Copyright © 2008, 2020, Oracle and/or its affiliates. All rights reserved.