oracle.sql

Class TIMESTAMPLTZ

java.lang.Object

oracle.sql.Datum

oracle.sql.TIMESTAMPLTZ

All Implemented Interfaces:

java.io.Serializable

public class TIMESTAMPLTZ
extends Datum

TIMESTAMPLTZ Class

The TIMESTAMPLTZ 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 eleven byte array in the super class' storage area. The bytes are arranged as follows:

      Byte       Represents
       0         Century (119 for 1990)
       1         Decade  (190 for 1990)
       2         Month
       3         Day      
       4         Hour
       5         Minute
       6         Seconds
       7         Nanoseconds (Most Significant bit)
       8         Nanoseconds
       9         Nanoseconds
       10        Nanoseconds (Least Significant Bit)
  

-We add 100 to the century and decade fields so that negative values will be positive and positive values will be higher than negative values -We add 1 to the month,hour,minute,second fields for the java objects since they start of from 0.

Static methods are used for conversions.

Since:

release specific (what release of product did this appear in)

See Also:

Serialized Form

Field Summary

Fields inherited from class oracle.sql.Datum

ojiOracleDatumWithConnection, targetDatum

Constructor Summary

Constructors

Constructor and Description
TIMESTAMPLTZ() Constructs a TIMESTAMPLTZ object initialized to 1/1/1970.
TIMESTAMPLTZ(byte[] timestampltz) Create an Oracle TIMESTAMPLTZ object represented by the given Oracle Timestampltz
TIMESTAMPLTZ(java.sql.Connection conn, java.util.Calendar sess, java.sql.Date date) Create an Oracle TIMESTAMPLTZ object represented by the Java Date
TIMESTAMPLTZ(java.sql.Connection conn, java.util.Calendar sess, DATE date) Create an Oracle TIMESTAMPLTZ object represented by the Oracle DATE
TIMESTAMPLTZ(java.sql.Connection conn, java.util.Calendar sess, java.lang.String str) Deprecated.
TIMESTAMPLTZ(java.sql.Connection conn, java.util.Calendar sess, java.sql.Time time) Create an Oracle TIMESTAMPLTZ object represented by the given Java Time
TIMESTAMPLTZ(java.sql.Connection conn, java.util.Calendar sess, java.sql.Timestamp timestamp) Create an Oracle TIMESTAMPLTZ object represented by the Java Timestamp
TIMESTAMPLTZ(java.sql.Connection conn, java.sql.Date date) Create an Oracle TIMESTAMPLTZ object represented by the Java Date
TIMESTAMPLTZ(java.sql.Connection conn, DATE date) Create an Oracle TIMESTAMPLTZ object represented by the Oracle DATE
TIMESTAMPLTZ(java.sql.Connection conn, java.sql.Date date, java.util.Calendar dbtz) Deprecated.
TIMESTAMPLTZ(java.sql.Connection conn, DATE date, java.util.Calendar dbtz) Deprecated.
TIMESTAMPLTZ(java.sql.Connection conn, java.time.LocalDateTime ldt) Create an Oracle TIMESTAMPLTZ object represented by the LocalDateTime
TIMESTAMPLTZ(java.sql.Connection conn, java.time.OffsetDateTime odt) Create an Oracle TIMESTAMPLTZ object represented by the OffsetDateTime
TIMESTAMPLTZ(java.sql.Connection conn, java.time.OffsetTime ot) Create an Oracle TIMESTAMPLTZ object represented by the OffsetTime
TIMESTAMPLTZ(java.sql.Connection conn, java.lang.String str) Deprecated.
TIMESTAMPLTZ(java.sql.Connection conn, java.lang.String str, java.util.Calendar dbtz) Deprecated.
TIMESTAMPLTZ(java.sql.Connection conn, java.sql.Time time) Create an Oracle TIMESTAMPLTZ object represented by the given Java Time
TIMESTAMPLTZ(java.sql.Connection conn, java.sql.Time time, java.util.Calendar dbtz) Deprecated.
TIMESTAMPLTZ(java.sql.Connection conn, java.sql.Timestamp timestamp) Create an Oracle TIMESTAMPLTZ object represented by the Java Timestamp
TIMESTAMPLTZ(java.sql.Connection conn, java.sql.Timestamp timestamp, java.util.Calendar dbtz) Deprecated.
TIMESTAMPLTZ(java.sql.Connection conn, java.time.ZonedDateTime zdt) Create an Oracle TIMESTAMPLTZ object represented by the ZonedDateTime

Method Summary

Modifier and Type	Method and Description
java.sql.Date	dateValue(java.sql.Connection conn) Calls toDate(Connection, byte[]) to convert internal Oracle TIMESTAMPLTZ to a Java Date.
java.sql.Date	dateValue(java.sql.Connection conn, java.util.Calendar cal) Calls toDate(Connection, byte[], Calendar) to convert internal Oracle TIMESTAMPLTZ to a Java Date.
boolean	isConvertibleTo(java.lang.Class<?> cls) Determines if the object can be converted to a particular class
java.time.LocalDateTime	localDateTimeValue(java.sql.Connection conn) Calls toLocalDateTime(Connection, byte[]) to convert internal Oracle TIMESTAMPLTZ to a Java LocalDateTime.
java.lang.Object	makeJdbcArray(int arraySize) Returns a JDBC array representation of the datum
static TIMESTAMPLTZ	of(java.sql.Connection conn, java.time.LocalDateTime ldt) Creates TIMESTAMPLTZ from the LocalDateTime.
static TIMESTAMPLTZ	of(java.sql.Connection conn, java.time.OffsetDateTime odt) Creates TIMESTAMPLTZ from the OffsetDateTime.
static TIMESTAMPLTZ	of(java.sql.Connection conn, java.time.OffsetTime ot) Creates TIMESTAMPLTZ from the OffsetTime.
static TIMESTAMPLTZ	of(java.sql.Connection conn, java.time.ZonedDateTime zdt) Creates TIMESTAMPLTZ from the ZonedDateTime.
java.time.OffsetDateTime	offsetDateTimeValue(java.sql.Connection conn) Calls toOffsetDateTime(Connection, byte[]) to convert internal Oracle TIMESTAMPLTZ to a Java OffsetDateTime.
java.time.OffsetTime	offsetTimeValue(java.sql.Connection conn) Calls toOffsetTime(Connection, byte[]) to convert internal Oracle TIMESTAMPLTZ to a Java OffsetTime.
java.lang.String	stringValue(java.sql.Connection conn) Calls toString(Connection, byte[]) to convert internal Oracle TIMESTAMPLTZ to a Java String.
java.lang.String	stringValue(java.sql.Connection conn, java.util.Calendar cal) Calls toString(Connection, byte[], Calendar) to convert internal Oracle TIMESTAMPLTZ to a Java String.
java.sql.Timestamp	timestampValue(java.sql.Connection conn)
java.sql.Timestamp	timestampValue(java.sql.Connection conn, java.util.Calendar dbtz) Calls toTimestamp to convert internal Oracle TIMESTAMPLTZ to a Java Timestamp.
java.sql.Time	timeValue(java.sql.Connection conn) Calls toTime to convert internal Oracle TIMESTAMPLTZ to a Java Time.
java.sql.Time	timeValue(java.sql.Connection conn, java.util.Calendar cal) Calls toTime to convert internal Oracle TIMESTAMPLTZ to a Java Time.
static void	TimeZoneAdjust(java.sql.Connection conn, java.util.Calendar cal1, java.util.Calendar cal2)
static long	TimeZoneAdjustUTC(java.sql.Connection conn, java.util.Calendar cal1)
byte[]	toBytes() Convert Oracle TIMESTAMPLTZ object into a byte array
static byte[]	toBytes(java.sql.Connection conn, java.util.Calendar cal, java.sql.Date date) Convert Java Date to Oracle TIMESTAMPLTZ.
static byte[]	toBytes(java.sql.Connection conn, java.util.Calendar cal, DATE date) Convert Oracle DATE to Oracle TIMESTAMPLTZ
static byte[]	toBytes(java.sql.Connection conn, java.util.Calendar sess, java.lang.String str) Convert Java String to Oracle TIMESTAMPLTZ.
static byte[]	toBytes(java.sql.Connection conn, java.util.Calendar cal, java.sql.Time time) Convert Java Time to Oracle TIMESTAMPLTZ.
static byte[]	toBytes(java.sql.Connection conn, java.util.Calendar cal, java.sql.Timestamp timestamp) Convert Java Timestamp to Oracle TIMESTAMPLTZ
static byte[]	toBytes(java.sql.Connection conn, java.sql.Date date, java.util.Calendar dbtz) Deprecated.
static byte[]	toBytes(java.sql.Connection conn, DATE date, java.util.Calendar dbtz) Deprecated.
static byte[]	toBytes(java.sql.Connection conn, java.time.LocalDateTime ldt) Convert Java LocalDateTime to Oracle TIMESTAMPLTZ.
static byte[]	toBytes(java.sql.Connection conn, java.time.OffsetDateTime odt) Convert Java OffsetDateTime to Oracle TIMESTAMPLTZ.
static byte[]	toBytes(java.sql.Connection conn, java.time.OffsetTime ot) Convert Java OffsetTime to Oracle TIMESTAMPLTZ.
static byte[]	toBytes(java.sql.Connection conn, java.lang.String str, java.util.Calendar dbtz) Convert Java String to Oracle TIMESTAMPLTZ.
static byte[]	toBytes(java.sql.Connection conn, java.sql.Time time, java.util.Calendar dbtz) Deprecated.
static byte[]	toBytes(java.sql.Connection conn, java.sql.Timestamp timestamp, java.util.Calendar dbtz) Deprecated.
static byte[]	toBytes(java.sql.Connection conn, java.time.ZonedDateTime zdt) Convert Java ZonedDateTime to Oracle TIMESTAMPLTZ.
static java.sql.Date	toDate(java.sql.Connection conn, byte[] timestampltz) Convert a byte array representing a TIMESTAMPLTZ object to a Java Date Object
static DATE	toDATE(java.sql.Connection conn, byte[] timestampltz) Convert a byte array representing a TIMESTAMPLTZ object to a Oracle DATE Object
static java.sql.Date	toDate(java.sql.Connection conn, byte[] timestampltz, java.util.Calendar dbtz) Deprecated.
static DATE	toDATE(java.sql.Connection conn, byte[] timestampltz, java.util.Calendar dbtz) Deprecated.
java.lang.Object	toJdbc() Returns the JDBC representation of the datum object
java.time.LocalDateTime	toLocalDateTime(java.sql.Connection conn) Convert a byte array representing a TIMESTAMPLTZ object to a Java LocalDateTime Object
static java.time.LocalDateTime	toLocalDateTime(java.sql.Connection conn, byte[] timestampltz) Convert a byte array representing a TIMESTAMPLTZ object to a Java LocalDateTime Object
static java.time.OffsetDateTime	toOffsetDateTime(java.sql.Connection conn, byte[] timestampltz) Convert a byte array representing a TIMESTAMPLTZ object to a Java OffsetDateTime Object
static java.time.OffsetTime	toOffsetTime(java.sql.Connection conn, byte[] timestampltz) Convert a byte array representing a TIMESTAMPLTZ object to a Java OffsetTime Object
static java.lang.String	toString(java.sql.Connection conn, byte[] timestampltz) Converts a TIMESTAMPLTZ to a string
static java.lang.String	toString(java.sql.Connection conn, byte[] timestampltz, java.util.Calendar dbtz) Deprecated.
static java.sql.Time	toTime(java.sql.Connection conn, byte[] timestampltz) Convert a byte array representing a TIMESTAMPLTZ object to a Java Time Object
static java.sql.Time	toTime(java.sql.Connection conn, byte[] timestampltz, java.util.Calendar dbtz) Deprecated.
static java.sql.Timestamp	toTimestamp(java.sql.Connection conn, byte[] timestampltz) Convert a byte array representing a TIMESTAMPLTZ object to a Java Timestamp Object
static TIMESTAMP	toTIMESTAMP(java.sql.Connection conn, byte[] timestampltz) Convert a byte array representing a TIMESTAMPLTZ object to a Oracle TIMESTAMP Object
static java.sql.Timestamp	toTimestamp(java.sql.Connection conn, byte[] timestampltz, java.util.Calendar dbtz) Deprecated.
static TIMESTAMPTZ	toTIMESTAMPTZ(java.sql.Connection conn, byte[] timestampltz) Convert a byte array representing a TIMESTAMPLTZ object to a Oracle TIMESTAMPTZ Object
static java.time.ZonedDateTime	toZonedDateTime(java.sql.Connection conn, byte[] timestampltz) Convert a byte array representing a TIMESTAMPLTZ object to a Java ZonedDateTime Object
java.time.ZonedDateTime	zonedDateTimeValue(java.sql.Connection conn) Calls toZonedDateTime(Connection, byte[]) to convert internal Oracle TIMESTAMPLTZ to a Java ZonedDateTime.

Methods inherited from class oracle.sql.Datum

asciiStreamValue, bigDecimalValue, binaryStreamValue, booleanValue, bytesEqual, bytesHashCode, byteValue, characterStreamValue, compareBytes, dateValue, doubleValue, equals, floatValue, getBytes, getConnectionDuringExceptionHandling, getLength, getStream, intValue, isNull, longValue, setBytes, setShareBytes, shareBytes, stringValue, timestampValue, timestampValue, timeValue, timeValue, toClass

Methods inherited from class java.lang.Object

clone, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

TIMESTAMPLTZ

public TIMESTAMPLTZ()

Constructs a TIMESTAMPLTZ object initialized to 1/1/1970.

TIMESTAMPLTZ

public TIMESTAMPLTZ(byte[] timestampltz)

Create an Oracle TIMESTAMPLTZ object represented by the given Oracle Timestampltz

Parameters:

Connection - conn

TIMESTAMPLTZ

public TIMESTAMPLTZ(java.sql.Connection conn,
                    java.sql.Time time,
                    java.util.Calendar dbtz)
             throws java.sql.SQLException

Deprecated.

Create an Oracle TIMESTAMPLTZ object represented by the given Java Time

Parameters:

conn - JDBC connection time Java Time object dbtz Calendar object containing Database Timezone

Throws:

java.sql.SQLException

TIMESTAMPLTZ

public TIMESTAMPLTZ(java.sql.Connection conn,
                    java.sql.Date date,
                    java.util.Calendar dbtz)
             throws java.sql.SQLException

Deprecated.

Create an Oracle TIMESTAMPLTZ object represented by the Java Date

Parameters:

conn - JDBC connection date Java Date object dbtz Calendar object containing Database Timezone

Throws:

java.sql.SQLException

TIMESTAMPLTZ

public TIMESTAMPLTZ(java.sql.Connection conn,
                    java.sql.Timestamp timestamp,
                    java.util.Calendar dbtz)
             throws java.sql.SQLException

Deprecated.

Create an Oracle TIMESTAMPLTZ object represented by the Java Timestamp

Parameters:

conn - Connection timestamp Java Timestamp object dbtz Calendar object containing Database Timezone

Throws:

java.sql.SQLException

TIMESTAMPLTZ

public TIMESTAMPLTZ(java.sql.Connection conn,
                    DATE date,
                    java.util.Calendar dbtz)
             throws java.sql.SQLException

Deprecated.

Create an Oracle TIMESTAMPLTZ object represented by the Oracle DATE

Parameters:

conn - JDBC connection date Oracle DATE object dbtz Calendar object containing Database Timezone

Throws:

java.sql.SQLException

TIMESTAMPLTZ

public TIMESTAMPLTZ(java.sql.Connection conn,
                    java.lang.String str,
                    java.util.Calendar dbtz)
             throws java.sql.SQLException

Deprecated.

Create a TIMESTAMPLTZ object given a Java String object.

Parameters:

conn - JDBC connection str Java String object dbtz Calendar object containing Database Timezone

Throws:

java.sql.SQLException

TIMESTAMPLTZ

public TIMESTAMPLTZ(java.sql.Connection conn,
                    java.util.Calendar sess,
                    java.sql.Time time)
             throws java.sql.SQLException

Create an Oracle TIMESTAMPLTZ object represented by the given Java Time

Parameters:

conn - JDBC connection sess Calendar object containing Session Timezone time Java Time object

Throws:

java.sql.SQLException

TIMESTAMPLTZ

public TIMESTAMPLTZ(java.sql.Connection conn,
                    java.util.Calendar sess,
                    java.sql.Date date)
             throws java.sql.SQLException

Create an Oracle TIMESTAMPLTZ object represented by the Java Date

Parameters:

conn - JDBC connection sess Calendar object containing Session Timezone date Java Date object

Throws:

java.sql.SQLException

TIMESTAMPLTZ

public TIMESTAMPLTZ(java.sql.Connection conn,
                    java.util.Calendar sess,
                    java.sql.Timestamp timestamp)
             throws java.sql.SQLException

Create an Oracle TIMESTAMPLTZ object represented by the Java Timestamp

Parameters:

conn - Connection sess Calendar object containing Session Timezone timestamp Java Timestamp object

Throws:

java.sql.SQLException

TIMESTAMPLTZ

public TIMESTAMPLTZ(java.sql.Connection conn,
                    java.util.Calendar sess,
                    DATE date)
             throws java.sql.SQLException

Create an Oracle TIMESTAMPLTZ object represented by the Oracle DATE

Parameters:

conn - JDBC connection sess Calendar object containing Session Timezone date Oracle DATE object

Throws:

java.sql.SQLException

TIMESTAMPLTZ

public TIMESTAMPLTZ(java.sql.Connection conn,
                    java.util.Calendar sess,
                    java.lang.String str)
             throws java.sql.SQLException

Deprecated.

Create a TIMESTAMPLTZ object given a Java String object.

Parameters:

conn - JDBC connection sess Calendar object containing Session Timezone str Java String object

Throws:

java.sql.SQLException

TIMESTAMPLTZ

public TIMESTAMPLTZ(java.sql.Connection conn,
                    java.sql.Time time)
             throws java.sql.SQLException

Create an Oracle TIMESTAMPLTZ object represented by the given Java Time

Parameters:

conn - JDBC connection time Java Time object

Throws:

java.sql.SQLException

TIMESTAMPLTZ

public TIMESTAMPLTZ(java.sql.Connection conn,
                    java.sql.Date date)
             throws java.sql.SQLException

Create an Oracle TIMESTAMPLTZ object represented by the Java Date

Parameters:

conn - JDBC connection date Java Date object

Throws:

java.sql.SQLException

TIMESTAMPLTZ

public TIMESTAMPLTZ(java.sql.Connection conn,
                    java.sql.Timestamp timestamp)
             throws java.sql.SQLException

Create an Oracle TIMESTAMPLTZ object represented by the Java Timestamp

Parameters:

conn - Connection timestamp Java Timestamp object

Throws:

java.sql.SQLException

TIMESTAMPLTZ

public TIMESTAMPLTZ(java.sql.Connection conn,
                    DATE date)
             throws java.sql.SQLException

Create an Oracle TIMESTAMPLTZ object represented by the Oracle DATE

Parameters:

conn - JDBC connection date Oracle DATE object

Throws:

java.sql.SQLException

TIMESTAMPLTZ

public TIMESTAMPLTZ(java.sql.Connection conn,
                    java.lang.String str)
             throws java.sql.SQLException

Deprecated.

Create a TIMESTAMPLTZ object given a Java String object.

Parameters:

conn - JDBC connection str Java String object

Throws:

java.sql.SQLException

TIMESTAMPLTZ

public TIMESTAMPLTZ(java.sql.Connection conn,
                    java.time.OffsetDateTime odt)
             throws java.sql.SQLException

Create an Oracle TIMESTAMPLTZ object represented by the OffsetDateTime

Parameters:

conn - JDBC connection odt OffsetDateTime object

Throws:

java.sql.SQLException

TIMESTAMPLTZ

public TIMESTAMPLTZ(java.sql.Connection conn,
                    java.time.OffsetTime ot)
             throws java.sql.SQLException

Create an Oracle TIMESTAMPLTZ object represented by the OffsetTime

Parameters:

conn - JDBC connection ot OffsetTime object

Throws:

java.sql.SQLException

TIMESTAMPLTZ

public TIMESTAMPLTZ(java.sql.Connection conn,
                    java.time.ZonedDateTime zdt)
             throws java.sql.SQLException

Create an Oracle TIMESTAMPLTZ object represented by the ZonedDateTime

Parameters:

conn - JDBC connection zdt ZonedDateTime object

Throws:

java.sql.SQLException

TIMESTAMPLTZ

public TIMESTAMPLTZ(java.sql.Connection conn,
                    java.time.LocalDateTime ldt)
             throws java.sql.SQLException

Create an Oracle TIMESTAMPLTZ object represented by the LocalDateTime

Parameters:

conn - JDBC connection ldt LocalDateTime object

Throws:

java.sql.SQLException

Method Detail

toDate

public static java.sql.Date toDate(java.sql.Connection conn,
                                   byte[] timestampltz,
                                   java.util.Calendar dbtz)
                            throws java.sql.SQLException

Deprecated.

Convert a byte array representing a TIMESTAMPLTZ object to a Java Date Object

Parameters:

conn - JDBC connection timestampltz Oracle TIMESTAMPLTZ object dbtz Database timezone

Returns:

the Java date object represented by Oracle TIMESTAMPLTZ object

Throws:

java.sql.SQLException

toTime

public static java.sql.Time toTime(java.sql.Connection conn,
                                   byte[] timestampltz,
                                   java.util.Calendar dbtz)
                            throws java.sql.SQLException

Deprecated.

Convert a byte array representing a TIMESTAMPLTZ object to a Java Time Object

Parameters:

conn - JDBC connection timestampltz Oracle TIMESTAMPLTZ object dbtz Database timezone

Returns:

the java.sql.Time object represented by Oracle TIMESTAMPLTZ object. Only the hour, minute and seconds are contained in the java.sql.Time object that is returned and hence callers should not attempt to access the date component of the returned object.

Throws:

java.sql.SQLException

toTimestamp

public static java.sql.Timestamp toTimestamp(java.sql.Connection conn,
                                             byte[] timestampltz,
                                             java.util.Calendar dbtz)
                                      throws java.sql.SQLException

Deprecated.

Convert a byte array representing a TIMESTAMPLTZ object to a Java Timestamp Object

Parameters:

conn - JDBC connection timestampltz Oracle TIMESTAMPLTZ object dbtz Database timezone

Returns:

the Java timestamp object represented by Oracle TIMESTAMPLTZ object

Throws:

java.sql.SQLException

toDATE

public static DATE toDATE(java.sql.Connection conn,
                          byte[] timestampltz,
                          java.util.Calendar dbtz)
                   throws java.sql.SQLException

Deprecated.

Convert a byte array representing a TIMESTAMPLTZ object to a Oracle DATE Object

Parameters:

conn - JDBC connection timestampltz Oracle TIMESTAMPLTZ object dbtz Database timezone

Returns:

the oracle DATE object represented by Oracle TIMESTAMPLTZ object

Throws:

java.sql.SQLException

timestampValue

public java.sql.Timestamp timestampValue(java.sql.Connection conn,
                                         java.util.Calendar dbtz)
                                  throws java.sql.SQLException

Calls toTimestamp to convert internal Oracle TIMESTAMPLTZ to a Java Timestamp.

Returns:

a Java Timestamp value

Throws:

java.sql.SQLException

timestampValue

public java.sql.Timestamp timestampValue(java.sql.Connection conn)
                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

toString

public static java.lang.String toString(java.sql.Connection conn,
                                        byte[] timestampltz,
                                        java.util.Calendar dbtz)
                                 throws java.sql.SQLException

Deprecated.

Converts a TIMESTAMPLTZ to a String

Parameters:

date - a byte array

Returns:

String representing the date

Throws:

java.sql.SQLException

toBytes

public byte[] toBytes()

Convert Oracle TIMESTAMPLTZ object into a byte array

Returns:

the byte array stored in the TIMESTAMPLTZ object

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.sql.Time time,
                             java.util.Calendar dbtz)
                      throws java.sql.SQLException

Deprecated.

Convert Java Time to Oracle TIMESTAMPLTZ.

Parameters:

conn - JDBC connection time java.sql.Time object to be converted. dbtz Database timezone

Returns:

the byte array representing the java Time.

Throws:

java.sql.SQLException

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.sql.Date date,
                             java.util.Calendar dbtz)
                      throws java.sql.SQLException

Deprecated.

Convert Java Date to Oracle TIMESTAMPLTZ.

Parameters:

conn - JDBC connection date java.sql.Date object to be converted. dbtz Database timezone

Returns:

the byte array representing the java Date.

Throws:

java.sql.SQLException

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.sql.Timestamp timestamp,
                             java.util.Calendar dbtz)
                      throws java.sql.SQLException

Deprecated.

Convert Java Timestamp to Oracle TIMESTAMPLTZ

Parameters:

conn - JDBC connection Timestamp java.sql.Timestamp object to be converted. dbtz database timezone

Returns:

the byte array representing the input date.

Throws:

java.sql.SQLException

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             DATE date,
                             java.util.Calendar dbtz)
                      throws java.sql.SQLException

Deprecated.

Convert Oracle DATE to Oracle TIMESTAMPLTZ

Parameters:

conn - JDBC connection date oracle.sql.DATE object to be converted. dbtz database timezone

Returns:

the byte array representing the Oracle DATE.

Throws:

java.sql.SQLException

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.lang.String str,
                             java.util.Calendar dbtz)
                      throws java.sql.SQLException

Convert Java String to Oracle TIMESTAMPLTZ.

Parameters:

conn - JDBC Connection str java.lang.String object to be converted. dbtz database timezone

Returns:

the byte array representing the input string.

Throws:

java.sql.SQLException

toDate

public static java.sql.Date toDate(java.sql.Connection conn,
                                   byte[] timestampltz)
                            throws java.sql.SQLException

Convert a byte array representing a TIMESTAMPLTZ object to a Java Date Object

Parameters:

conn - JDBC connection timestampltz Oracle TIMESTAMPLTZ object

Returns:

the Java date object represented by Oracle TIMESTAMPLTZ object

Throws:

java.sql.SQLException

toLocalDateTime

public java.time.LocalDateTime toLocalDateTime(java.sql.Connection conn)
                                        throws java.sql.SQLException

Convert a byte array representing a TIMESTAMPLTZ object to a Java LocalDateTime Object

Parameters:

conn - JDBC connection

Returns:

the Java LocalDateTime object represented by the Oracle TIMESTAMPLTZ object

Throws:

java.sql.SQLException

toLocalDateTime

public static java.time.LocalDateTime toLocalDateTime(java.sql.Connection conn,
                                                      byte[] timestampltz)
                                               throws java.sql.SQLException

Convert a byte array representing a TIMESTAMPLTZ object to a Java LocalDateTime Object

Parameters:

conn - JDBC connection timestampltz Oracle TIMESTAMPLTZ object

Returns:

the Java LocalDateTime object represented by the Oracle TIMESTAMPLTZ object

Throws:

java.sql.SQLException

of

public static TIMESTAMPLTZ of(java.sql.Connection conn,
                              java.time.OffsetDateTime odt)
                       throws java.sql.SQLException

Creates TIMESTAMPLTZ from the OffsetDateTime.

Parameters:

odt - OffsetDateTime object

Returns:

TIMESTAMPLTZ object

Throws:

java.sql.SQLException

of

public static TIMESTAMPLTZ of(java.sql.Connection conn,
                              java.time.OffsetTime ot)
                       throws java.sql.SQLException

Creates TIMESTAMPLTZ from the OffsetTime.

Parameters:

ot - OffsetTime object

Returns:

TIMESTAMPLTZ object

Throws:

java.sql.SQLException

of

public static TIMESTAMPLTZ of(java.sql.Connection conn,
                              java.time.ZonedDateTime zdt)
                       throws java.sql.SQLException

Creates TIMESTAMPLTZ from the ZonedDateTime.

Parameters:

zdt - ZonedDateTime object

Returns:

TIMESTAMPLTZ object

Throws:

java.sql.SQLException

of

public static TIMESTAMPLTZ of(java.sql.Connection conn,
                              java.time.LocalDateTime ldt)
                       throws java.sql.SQLException

Creates TIMESTAMPLTZ from the LocalDateTime.

Parameters:

ldt - LocalDateTime object

Returns:

TIMESTAMPLTZ object

Throws:

java.sql.SQLException

toOffsetDateTime

public static java.time.OffsetDateTime toOffsetDateTime(java.sql.Connection conn,
                                                        byte[] timestampltz)
                                                 throws java.sql.SQLException

Convert a byte array representing a TIMESTAMPLTZ object to a Java OffsetDateTime Object

Parameters:

conn - JDBC connection timestampltz Oracle TIMESTAMPLTZ object

Returns:

the Java OffsetDateTime object represented by the Oracle TIMESTAMPLTZ object

Throws:

java.sql.SQLException

toOffsetTime

public static java.time.OffsetTime toOffsetTime(java.sql.Connection conn,
                                                byte[] timestampltz)
                                         throws java.sql.SQLException

Convert a byte array representing a TIMESTAMPLTZ object to a Java OffsetTime Object

Parameters:

conn - JDBC connection timestampltz Oracle TIMESTAMPLTZ object

Returns:

the Java OffsetTime object represented by the Oracle TIMESTAMPLTZ object

Throws:

java.sql.SQLException

toZonedDateTime

public static java.time.ZonedDateTime toZonedDateTime(java.sql.Connection conn,
                                                      byte[] timestampltz)
                                               throws java.sql.SQLException

Convert a byte array representing a TIMESTAMPLTZ object to a Java ZonedDateTime Object

Parameters:

conn - JDBC connection timestampltz Oracle TIMESTAMPLTZ object

Returns:

the Java ZonedDateTime object represented by the Oracle TIMESTAMPLTZ object

Throws:

java.sql.SQLException

toTime

public static java.sql.Time toTime(java.sql.Connection conn,
                                   byte[] timestampltz)
                            throws java.sql.SQLException

Convert a byte array representing a TIMESTAMPLTZ object to a Java Time Object

Parameters:

conn - JDBC connection timestampltz Oracle TIMESTAMPLTZ object

Returns:

the Java time object represented by Oracle TIMESTAMPLTZ object

Throws:

java.sql.SQLException

toTimestamp

public static java.sql.Timestamp toTimestamp(java.sql.Connection conn,
                                             byte[] timestampltz)
                                      throws java.sql.SQLException

Convert a byte array representing a TIMESTAMPLTZ object to a Java Timestamp Object

Parameters:

conn - JDBC connection timestamp Oracle TIMESTAMP object

Returns:

the Java timestamp object represented by Oracle TIMESTAMP object

Throws:

java.sql.SQLException

toDATE

public static DATE toDATE(java.sql.Connection conn,
                          byte[] timestampltz)
                   throws java.sql.SQLException

Convert a byte array representing a TIMESTAMPLTZ object to a Oracle DATE Object

Parameters:

conn - JDBC connection timestampltz Oracle TIMESTAMPLTZ object

Returns:

the Oracle DATE object represented by Oracle TIMESTAMPLTZ object

Throws:

java.sql.SQLException

toTIMESTAMP

public static TIMESTAMP toTIMESTAMP(java.sql.Connection conn,
                                    byte[] timestampltz)
                             throws java.sql.SQLException

Convert a byte array representing a TIMESTAMPLTZ object to a Oracle TIMESTAMP Object

Parameters:

conn - JDBC connection timestamp Oracle TIMESTAMPLTZ object

Returns:

the oracle TIMESTAMP object represented by Oracle TIMESTAMPLTZ object

Throws:

java.sql.SQLException

toTIMESTAMPTZ

public static TIMESTAMPTZ toTIMESTAMPTZ(java.sql.Connection conn,
                                        byte[] timestampltz)
                                 throws java.sql.SQLException

Convert a byte array representing a TIMESTAMPLTZ object to a Oracle TIMESTAMPTZ Object

Parameters:

conn - JDBC connection timestamp Oracle TIMESTAMPLTZ object

Returns:

the oracle TIMESTAMPTZ object represented by Oracle TIMESTAMPLTZ object

Throws:

java.sql.SQLException

toString

public static java.lang.String toString(java.sql.Connection conn,
                                        byte[] timestampltz)
                                 throws java.sql.SQLException

Converts a TIMESTAMPLTZ to a string

Parameters:

date - a byte array

Returns:

String representing the date

Throws:

java.sql.SQLException

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.util.Calendar cal,
                             java.sql.Time time)
                      throws java.sql.SQLException

Convert Java Time to Oracle TIMESTAMPLTZ.

Parameters:

conn - JDBC connection cal Session timezone time java.sql.Time object to be converted.

Returns:

the byte array representing the java Time.

Throws:

java.sql.SQLException

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.util.Calendar cal,
                             java.sql.Date date)
                      throws java.sql.SQLException

Convert Java Date to Oracle TIMESTAMPLTZ.

Parameters:

conn - JDBC connection cal Session timezone date java.sql.Date object to be converted.

Returns:

the byte array representing the java Date.

Throws:

java.sql.SQLException

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.util.Calendar cal,
                             java.sql.Timestamp timestamp)
                      throws java.sql.SQLException

Convert Java Timestamp to Oracle TIMESTAMPLTZ

Parameters:

conn - JDBC connection cal Session timezone Timestamp java.sql.Timestamp object to be converted.

Returns:

the byte array representing the input date.

Throws:

java.sql.SQLException

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.util.Calendar cal,
                             DATE date)
                      throws java.sql.SQLException

Convert Oracle DATE to Oracle TIMESTAMPLTZ

Parameters:

conn - JDBC connection cal Session timezone date oracle.sql.DATE object to be converted.

Returns:

the byte array representing the Oracle DATE.

Throws:

java.sql.SQLException

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.util.Calendar sess,
                             java.lang.String str)
                      throws java.sql.SQLException

Convert Java String to Oracle TIMESTAMPLTZ.

Parameters:

conn - JDBC Connection sess Calendar object containing Session Timezone str java.lang.String object to be converted.

Returns:

the byte array representing the input string.

Throws:

java.sql.SQLException

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.time.OffsetTime ot)
                      throws java.sql.SQLException

Convert Java OffsetTime to Oracle TIMESTAMPLTZ.

Parameters:

conn - JDBC Connection odt OffsetTime object

Returns:

the byte array representing the input string.

Throws:

java.sql.SQLException

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.time.ZonedDateTime zdt)
                      throws java.sql.SQLException

Convert Java ZonedDateTime to Oracle TIMESTAMPLTZ.

Parameters:

conn - JDBC Connection zdt ZonedDateTime object

Returns:

the byte array representing the input string.

Throws:

java.sql.SQLException

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.time.OffsetDateTime odt)
                      throws java.sql.SQLException

Convert Java OffsetDateTime to Oracle TIMESTAMPLTZ.

Parameters:

conn - JDBC Connection odt OffsetDateTime object

Returns:

the byte array representing the input string.

Throws:

java.sql.SQLException

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.time.LocalDateTime ldt)
                      throws java.sql.SQLException

Convert Java LocalDateTime to Oracle TIMESTAMPLTZ.

Parameters:

conn - JDBC Connection ldt LocalDateTime object

Returns:

the byte array representing the input string.

Throws:

java.sql.SQLException

stringValue

public java.lang.String stringValue(java.sql.Connection conn)
                             throws java.sql.SQLException

Calls toString(Connection, byte[]) to convert internal Oracle TIMESTAMPLTZ to a Java String.

Overrides:

stringValue in class Datum

Parameters:

conn - oracle.JDBC.OracleConnection object

Returns:

a Java String value

Throws:

java.sql.SQLException

stringValue

public java.lang.String stringValue(java.sql.Connection conn,
                                    java.util.Calendar cal)
                             throws java.sql.SQLException

Calls toString(Connection, byte[], Calendar) to convert internal Oracle TIMESTAMPLTZ to a Java String.

Parameters:

conn - oracle.JDBC.OracleConnection object cal java.util.Calendar object

Returns:

a Java String value

Throws:

java.sql.SQLException

dateValue

public java.sql.Date dateValue(java.sql.Connection conn,
                               java.util.Calendar cal)
                        throws java.sql.SQLException

Calls toDate(Connection, byte[], Calendar) to convert internal Oracle TIMESTAMPLTZ to a Java Date.

Parameters:

conn - JDBC Connection object cal java.util.Calendar object

Returns:

a Java Date

Throws:

java.sql.SQLException

dateValue

public java.sql.Date dateValue(java.sql.Connection conn)
                        throws java.sql.SQLException

Calls toDate(Connection, byte[]) to convert internal Oracle TIMESTAMPLTZ to a Java Date.

Parameters:

conn - JDBC Connection object

Returns:

a Java Date

Throws:

java.sql.SQLException

localDateTimeValue

public java.time.LocalDateTime localDateTimeValue(java.sql.Connection conn)
                                           throws java.sql.SQLException

Calls toLocalDateTime(Connection, byte[]) to convert internal Oracle TIMESTAMPLTZ to a Java LocalDateTime.

Parameters:

conn - JDBC Connection object

Returns:

a Java LocalDateTime

Throws:

java.sql.SQLException

offsetDateTimeValue

public java.time.OffsetDateTime offsetDateTimeValue(java.sql.Connection conn)
                                             throws java.sql.SQLException

Calls toOffsetDateTime(Connection, byte[]) to convert internal Oracle TIMESTAMPLTZ to a Java OffsetDateTime.

Parameters:

conn - JDBC Connection object

Returns:

a Java OffsetDateTime

Throws:

java.sql.SQLException

offsetTimeValue

public java.time.OffsetTime offsetTimeValue(java.sql.Connection conn)
                                     throws java.sql.SQLException

Calls toOffsetTime(Connection, byte[]) to convert internal Oracle TIMESTAMPLTZ to a Java OffsetTime.

Parameters:

conn - JDBC Connection object

Returns:

a Java OffsetTime

Throws:

java.sql.SQLException

zonedDateTimeValue

public java.time.ZonedDateTime zonedDateTimeValue(java.sql.Connection conn)
                                           throws java.sql.SQLException

Calls toZonedDateTime(Connection, byte[]) to convert internal Oracle TIMESTAMPLTZ to a Java ZonedDateTime.

Parameters:

conn - JDBC Connection object

Returns:

a Java ZonedDateTime

Throws:

java.sql.SQLException

timeValue

public java.sql.Time timeValue(java.sql.Connection conn)
                        throws java.sql.SQLException

Calls toTime to convert internal Oracle TIMESTAMPLTZ to a Java Time.

Returns:

a Java Time value

Throws:

java.sql.SQLException

timeValue

public java.sql.Time timeValue(java.sql.Connection conn,
                               java.util.Calendar cal)
                        throws java.sql.SQLException

Calls toTime to convert internal Oracle TIMESTAMPLTZ to a Java Time.

Returns:

a Java Time value

Throws:

java.sql.SQLException

toJdbc

public java.lang.Object toJdbc()
                        throws java.sql.SQLException

Returns the JDBC representation of the datum object

Specified by:

toJdbc in class Datum

Returns:

an object containing the JDBC value

Throws:

java.sql.SQLException - if conversion to JDBC representation results in an error

makeJdbcArray

public java.lang.Object makeJdbcArray(int arraySize)

Returns a JDBC array representation of the datum

Specified by:

makeJdbcArray in class Datum

Parameters:

arraySize - size of the array

Returns:

an object containing the JDBC array value

isConvertibleTo

public boolean isConvertibleTo(java.lang.Class<?> cls)

Determines if the object can be converted to a particular class

Specified by:

isConvertibleTo in class Datum

Parameters:

cls - Class to convert to

Returns:

true, if conversion to cls is permitted false, if conversion to cls is not permitted

TimeZoneAdjust

public static void TimeZoneAdjust(java.sql.Connection conn,
                                  java.util.Calendar cal1,
                                  java.util.Calendar cal2)
                           throws java.sql.SQLException

Throws:

java.sql.SQLException

TimeZoneAdjustUTC

public static long TimeZoneAdjustUTC(java.sql.Connection conn,
                                     java.util.Calendar cal1)
                              throws java.sql.SQLException

Throws:

java.sql.SQLException