Uses of Class oracle.sql.DATE (Oracle Database JDBC Java API Reference)

Packages that use DATE
Package	Description
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
Modifier and Type	Method	Description
`DATE`	OracleConnection.`createDATE(String 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`	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`	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(String 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, Calendar cal)`	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, Calendar cal)`	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, 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(String columnName)`	Oracle extension.

Methods in oracle.jdbc with parameters of type DATE
Modifier and Type	Method	Description
`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.
`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.
`TIMESTAMPTZ`	OracleConnection.`createTIMESTAMPTZ(DATE value)`
`TIMESTAMPTZ`	OracleConnectionWrapper.`createTIMESTAMPTZ(DATE value)`
`void`	OracleCallableStatement.`setDATE(String parameterName, DATE x)`	Sets the designated parameter to an `oracle.sql.DATE`value.
`void`	OraclePreparedStatement.`setDATE(int parameterIndex, DATE date)`	Binds the designated parameter to a `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(String columnName, DATE value)`	Oracle extension.

Uses of DATE in oracle.sql

Methods in oracle.sql that return DATE
Modifier and Type	Method	Description
`DATE`	DATE.`addJulianDays(int julianDay, int julianSec)`	Add Julian days 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.`fromText(String datestr, String fmt, String lang)`	Convert a string to a DATE object.
`static DATE`	DATE.`getCurrentDate()`	Gets current date and time
`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.LocalDateTime ldt)`	Creates DATE from the LocalDateTime.
`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.`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`	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`	TIMESTAMPTZ.`toDATE(Connection conn, byte[] timestamptz)`	Convert a byte array representing a TIMESTAMPTZ object to a Oracle DATE Object
`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.

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

Constructors in oracle.sql with parameters of type DATE
Constructor	Description
`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, DATE date)`	Create an Oracle TIMESTAMPLTZ object represented by the Oracle DATE
`TIMESTAMPLTZ(Connection conn, DATE date, Calendar dbtz)`	Deprecated.
`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
Modifier and Type Method Description

DATE OracleJsonDate.getDATE()
Returns this value as a SQL DATE.