Package oracle.sql

Class TIMESTAMPTZ

java.lang.Object

oracle.sql.Datum

oracle.sql.TIMESTAMPTZ

All Implemented Interfaces:

Serializable, oracle.jdbc.internal.OracleTimestampWithTimeZone

public class TIMESTAMPTZ
extends Datum
implements oracle.jdbc.internal.OracleTimestampWithTimeZone

TIMESTAMPTZ Class

The TIMESTAMPTZ 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 thirteen 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)
       11,12     Region id or Timezone Hour/Minute         
  

The timezone information is stored as an offset in the RegionID format or in the HOUR/MINUTE format

Static methods are used for conversions.

See Also:

Serialized Form

<section role="region">

Field Summary

Fields inherited from class oracle.sql.Datum

ojiOracleDatumWithConnection, targetDatum </section> <section role="region">

Constructor Summary

Constructors

Constructor	Description
TIMESTAMPTZ()	Constructs a TIMESTAMPTZ object initialized to 1/1/1970.
TIMESTAMPTZ(byte[] timestamptz)	Create an Oracle TIMESTAMPTZ object represented by the given Oracle Timestamptz
TIMESTAMPTZ(Connection conn, String str)	Create a TIMESTAMPTZ object given a Java String object.
TIMESTAMPTZ(Connection conn, String str, Calendar cal)	Create a TIMESTAMPTZ object given a Java String object.
TIMESTAMPTZ(Connection conn, Date date)	Create an Oracle TIMESTAMPTZ object represented by the Java Date
TIMESTAMPTZ(Connection conn, Date date, Calendar cal)	Create an Oracle TIMESTAMPTZ object represented by the Java Date and the Java Calendar object
TIMESTAMPTZ(Connection conn, Time time)	Create an Oracle TIMESTAMPTZ object represented by the given Java Time
TIMESTAMPTZ(Connection conn, Time time, Calendar cal)	Create an Oracle TIMESTAMPTZ object represented by the given Java Time and the Java Calendar object
TIMESTAMPTZ(Connection conn, Timestamp timestamp)	Create an Oracle TIMESTAMPTZ object represented by the Java Timestamp
TIMESTAMPTZ(Connection conn, Timestamp timestamp, java.time.ZoneId tzid)	Create an Oracle TIMESTAMPTZ object represented by the Java Timestamp with the specified ZoneId.
TIMESTAMPTZ(Connection conn, Timestamp timestamp, Calendar cal)	Create an Oracle TIMESTAMPTZ object represented by the Java Timestamp and the Java Calendar object
TIMESTAMPTZ(Connection conn, DATE date)	Create an Oracle TIMESTAMPTZ object represented by the Oracle DATE

</section> <section role="region">

Method Summary

Modifier and Type	Method	Description
Date	dateValue(Connection conn)	Calls toDate to convert internal Oracle TIMESTAMPTZ to a Java Date.
TimeZone	getTimeZone()
boolean	isConvertibleTo(Class cls)	Determines if the object can be converted to a particular class
Object	makeJdbcArray(int arraySize)	Returns a JDBC array representation of the datum
static TIMESTAMPTZ	of(java.time.OffsetDateTime odt)	Creates TIMESTAMPTZ from the OffsetDateTime.
static TIMESTAMPTZ	of(java.time.ZonedDateTime zdt)	Creates TIMESTAMPTZ from the LocalDateTime.
java.time.OffsetDateTime	offsetDateTimeValue(Connection conn)	Calls toOffsetDateTime to convert internal Oracle TIMESTAMPTZ to a Java OffsetDateTime.
String	stringValue(Connection conn)	Calls toString to convert internal Oracle TIMESTAMPTZ to a Java String.
Timestamp	timestampValue(Connection conn)	Calls toTimestamp to convert internal Oracle Date to a Java Timestamp.
Time	timeValue(Connection conn)	Calls toTime to convert internal Oracle Date to a Java Time.
byte[]	toBytes()	Convert Oracle Timestamptz object into a byte array
static byte[]	toBytes(Connection conn, String str)	Convert Java String to Oracle TIMESTAMPTZ.
static byte[]	toBytes(Connection conn, String str, Calendar cal)	Convert Java String to Oracle TIMESTAMPTZ.
static byte[]	toBytes(Connection conn, Date date)	Convert Java Date to Oracle TIMESTAMPTZ.
static byte[]	toBytes(Connection conn, Date date, Calendar cal)	Convert Java Date to Oracle TIMESTAMPTZ.
static byte[]	toBytes(Connection conn, Time time)	Convert Java Time to Oracle TIMESTAMPTZ.
static byte[]	toBytes(Connection conn, Time time, Calendar cal)	Convert Java Time to Oracle TIMESTAMPTZ.
static byte[]	toBytes(Connection conn, Timestamp timestamp)	Convert Java Timestamp to Oracle TIMESTAMPTZ
static byte[]	toBytes(Connection conn, Timestamp timestamp, java.time.ZoneId tzid)	Convert Java Timestamp to Oracle TIMESTAMPTZ
static byte[]	toBytes(Connection conn, Timestamp timestamp, Calendar cal)	Convert Java Timestamp to Oracle TIMESTAMPTZ
static byte[]	toBytes(Connection conn, DATE date)	Convert Oracle DATE to Oracle TIMESTAMPTZ
static Date	toDate(Connection conn, byte[] timestamptz)	Convert a byte array representing a TIMESTAMPTZ object to a Java Date Object
static DATE	toDATE(Connection conn, byte[] timestamptz)	Convert a byte array representing a TIMESTAMPTZ object to a Oracle DATE Object
static Date	toDate2(Connection conn, byte[] timestamptz)	Convert a byte array representing a TIMESTAMPTZ object to a Java Date Object in accordance with java.sql.Date specification.
Object	toJdbc()	Returns the JDBC representation of the timestamptz object
java.time.OffsetDateTime	toOffsetDateTime()	Converts TIMESTAMPTZ to OffsetDateTime.
static java.time.OffsetDateTime	toOffsetDateTime(Connection conn, byte[] timestamptz)	Converts a TIMESTAMPTZ to an OffsetDateTime
static String	toString(Connection conn, byte[] timestamptz)	Converts a TIMESTAMPTZ to a string
static Time	toTime(Connection conn, byte[] timestamptz)	Convert a byte array representing a TIMESTAMPTZ object to a Java Time Object
static Timestamp	toTimestamp(Connection conn, byte[] timestamptz)	Convert a byte array representing a TIMESTAMP WITH TIME ZONE object to a Java Timestamp Object
static TIMESTAMP	toTIMESTAMP(Connection conn, byte[] timestamptz)	Convert a byte array representing a TIMESTAMPTZ object to a Oracle TIMESTAMP Object
static Timestamp	toTimestamp2(Connection conn, byte[] timestamptz)	Convert a byte array representing a TIMESTAMPTZ object to a Java Timestamp Object
java.time.ZonedDateTime	toZonedDateTime()	Converts TIMESTAMPTZ to 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 </section>

<section role="region">

Constructor Detail

TIMESTAMPTZ

public TIMESTAMPTZ()

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

TIMESTAMPTZ

public TIMESTAMPTZ(byte[] timestamptz)

Create an Oracle TIMESTAMPTZ object represented by the given Oracle Timestamptz

Parameters:

timestamptz - Oracle TIMESTAMPTZ

TIMESTAMPTZ

public TIMESTAMPTZ(Connection conn,
                   Date date)
            throws SQLException

Create an Oracle TIMESTAMPTZ object represented by the Java Date

Parameters:

conn - JDBC connection date Java Date object

Throws:

SQLException

TIMESTAMPTZ

public TIMESTAMPTZ(Connection conn,
                   Date date,
                   Calendar cal)
            throws SQLException

Create an Oracle TIMESTAMPTZ object represented by the Java Date and the Java Calendar object

Parameters:

conn - JDBC connection date Java Date object cal java Calendar object

Throws:

SQLException

TIMESTAMPTZ

public TIMESTAMPTZ(Connection conn,
                   Time time)
            throws SQLException

Create an Oracle TIMESTAMPTZ object represented by the given Java Time

Parameters:

conn - JDBC connection time Java Time object

Throws:

SQLException

TIMESTAMPTZ

public TIMESTAMPTZ(Connection conn,
                   Time time,
                   Calendar cal)
            throws SQLException

Create an Oracle TIMESTAMPTZ object represented by the given Java Time and the Java Calendar object

Parameters:

conn - JDBC connection time Java Time object cal java Calendar object

Throws:

SQLException

TIMESTAMPTZ

public TIMESTAMPTZ(Connection conn,
                   Timestamp timestamp)
            throws SQLException

Create an Oracle TIMESTAMPTZ object represented by the Java Timestamp

Parameters:

conn - JDBC connection timestamp Java Timestamp object

Throws:

SQLException

TIMESTAMPTZ

public TIMESTAMPTZ(Connection conn,
                   Timestamp timestamp,
                   Calendar cal)
            throws SQLException

Create an Oracle TIMESTAMPTZ object represented by the Java Timestamp and the Java Calendar object

Parameters:

conn - JDBC connection timestamp Java Timestamp object cal Java Calendar object

Throws:

SQLException

TIMESTAMPTZ

public TIMESTAMPTZ(Connection conn,
                   Timestamp timestamp,
                   java.time.ZoneId tzid)
            throws SQLException

Create an Oracle TIMESTAMPTZ object represented by the Java Timestamp with the specified ZoneId.

Parameters:

conn - JDBC connection timestamp Java Timestamp object tzidstamp Java ZoneId object

Throws:

SQLException

TIMESTAMPTZ

public TIMESTAMPTZ(Connection conn,
                   DATE date)
            throws SQLException

Create an Oracle TIMESTAMPTZ object represented by the Oracle DATE

Parameters:

conn - JDBC connection date Oracle DATE object

Throws:

SQLException

TIMESTAMPTZ

public TIMESTAMPTZ(Connection conn,
                   String str)
            throws SQLException

Create a TIMESTAMPTZ object given a Java String object.

Parameters:

conn - JDBC connection str Java String object

Throws:

SQLException

TIMESTAMPTZ

public TIMESTAMPTZ(Connection conn,
                   String str,
                   Calendar cal)
            throws SQLException

Create a TIMESTAMPTZ object given a Java String object.

Parameters:

conn - JDBC connection str Java String object cal Calendar object encapsulating the timezone

Throws:

SQLException

</section> <section role="region">

Method Detail

toDate

public static Date toDate(Connection conn,
                          byte[] timestamptz)
                   throws SQLException

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

Parameters:

conn - JDBC connection timestamptz Oracle TIMESTAMPTZ object

Returns:

the Java Date object represented by Oracle TIMESTAMPTZ object

Throws:

SQLException

toDate2

public static Date toDate2(Connection conn,
                           byte[] timestamptz)
                    throws SQLException

Convert a byte array representing a TIMESTAMPTZ object to a Java Date Object in accordance with java.sql.Date specification.

Parameters:

conn - JDBC connection timestamptz Oracle TIMESTAMPTZ object in byte array

Returns:

the Java Date object represented by Oracle TIMESTAMPTZ object as per java.sql.Date standards. i.e w.r.t GMT timezone

Throws:

SQLException

toTime

public static Time toTime(Connection conn,
                          byte[] timestamptz)
                   throws SQLException

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

Parameters:

conn - JDBC connection timestamptz Oracle TIMESTAMPTZ object

Returns:

the java.sql.Time object represented by Oracle TIMESTAMPTZ 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:

SQLException

toDATE

public static DATE toDATE(Connection conn,
                          byte[] timestamptz)
                   throws SQLException

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

Parameters:

conn - JDBC connection timestamptz Oracle TIMESTAMPTZ object

Returns:

the oracle DATE object represented by Oracle TIMESTAMPTZ object

Throws:

SQLException

toTIMESTAMP

public static TIMESTAMP toTIMESTAMP(Connection conn,
                                    byte[] timestamptz)
                             throws SQLException

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

Parameters:

conn - JDBC connection timestamptz Oracle TIMESTAMPTZ object

Returns:

the Oracle TIMESTAMP object represented by Oracle TIMESTAMPTZ object

Throws:

SQLException

toTimestamp

public static Timestamp toTimestamp(Connection conn,
                                    byte[] timestamptz)
                             throws SQLException

Convert a byte array representing a TIMESTAMP WITH TIME ZONE object to a Java Timestamp Object

Parameters:

conn - JDBC connection timestamptz Oracle TIMESTAMPTZ object

Returns:

the Java Timestamp object represented by Oracle TIMESTAMPTZ object

Throws:

SQLException

toTimestamp2

public static Timestamp toTimestamp2(Connection conn,
                                     byte[] timestamptz)
                              throws SQLException

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

Parameters:

conn - JDBC connection timestamptz Oracle TIMESTAMPTZ object

Returns:

the Java Timestamp object represented by Oracle TIMESTAMPTZ object

Throws:

SQLException

toString

public static String toString(Connection conn,
                              byte[] timestamptz)
                       throws SQLException

Converts a TIMESTAMPTZ to a string

Parameters:

timestamptz - a byte array

Returns:

String representing the TIMESTAMPTZ

Throws:

SQLException

toOffsetDateTime

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

Converts a TIMESTAMPTZ to an OffsetDateTime

Parameters:

timestamptz - a byte array

Returns:

OffsetDateTime representing the TIMESTAMPTZ

Throws:

SQLException

timestampValue

public Timestamp timestampValue(Connection conn)
                         throws SQLException

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

Returns:

a Java Timestamp value

Throws:

SQLException

toBytes

public byte[] toBytes()

Convert Oracle Timestamptz object into a byte array

Specified by:

toBytes in interface oracle.jdbc.internal.OracleTimestampWithTimeZone

Returns:

the byte array stored in the TIMESTAMPTZ object

toBytes

public static byte[] toBytes(Connection conn,
                             Date date)
                      throws SQLException

Convert Java Date to Oracle TIMESTAMPTZ.

Parameters:

conn - JDBC connection date Java Date object

Returns:

the byte array representing the java Date.

Throws:

SQLException

toBytes

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

Convert Java Date to Oracle TIMESTAMPTZ.

Parameters:

conn - JDBC connection date Java Date object cal java Calendar object

Returns:

the byte array representing the java Date.

Throws:

SQLException

toBytes

public static byte[] toBytes(Connection conn,
                             Time time)
                      throws SQLException

Convert Java Time to Oracle TIMESTAMPTZ.

Parameters:

conn - JDBC connection time Java Time object

Returns:

the byte array representing the java Time.

Throws:

SQLException

toBytes

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

Convert Java Time to Oracle TIMESTAMPTZ.

Parameters:

conn - JDBC connection time Java Time object cal java Calendar object

Returns:

the byte array representing the java Time.

Throws:

SQLException

toBytes

public static byte[] toBytes(Connection conn,
                             Timestamp timestamp)
                      throws SQLException

Convert Java Timestamp to Oracle TIMESTAMPTZ

Parameters:

conn - JDBC connection timestamp Java Timestamp object

Returns:

the byte array representing the TIMESTAMPTZ object.

Throws:

SQLException

toBytes

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

Convert Java Timestamp to Oracle TIMESTAMPTZ

Parameters:

conn - JDBC connection timestamp Java Timestamp object cal Java Calendar object

Returns:

the byte array representing the TIMESTAMPTZ object.

Throws:

SQLException

toBytes

public static byte[] toBytes(Connection conn,
                             Timestamp timestamp,
                             java.time.ZoneId tzid)
                      throws SQLException

Convert Java Timestamp to Oracle TIMESTAMPTZ

Parameters:

conn - JDBC connection timestamp Java Timestamp object tzid Java ZoneId object

Returns:

the byte array representing the TIMESTAMPTZ object.

Throws:

SQLException

toBytes

public static byte[] toBytes(Connection conn,
                             DATE date)
                      throws SQLException

Convert Oracle DATE to Oracle TIMESTAMPTZ

Parameters:

conn - JDBC connection date Oracle DATE object

Returns:

the byte array representing the Oracle TIMESTAMPTZ.

Throws:

SQLException

toBytes

public static byte[] toBytes(Connection conn,
                             String str)
                      throws SQLException

Convert Java String to Oracle TIMESTAMPTZ.

Parameters:

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

Returns:

the byte array representing the input string.

Throws:

SQLException

toBytes

public static byte[] toBytes(Connection conn,
                             String str,
                             Calendar cal)
                      throws SQLException

Convert Java String to Oracle TIMESTAMPTZ.

Parameters:

conn - JDBC Connection str java.lang.String object to be converted. cal Calendar object encapsulating the timezone

Returns:

the byte array representing the input string.

Throws:

SQLException

stringValue

public String stringValue(Connection conn)
                   throws SQLException

Calls toString to convert internal Oracle TIMESTAMPTZ to a Java String.

Specified by:

stringValue in interface oracle.jdbc.internal.OracleTimestampWithTimeZone

Overrides:

stringValue in class Datum

Parameters:

conn - oracle.JDBC.OracleConnection object

Returns:

a Java String value

Throws:

SQLException

offsetDateTimeValue

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

Calls toOffsetDateTime to convert internal Oracle TIMESTAMPTZ to a Java OffsetDateTime.

Parameters:

a - JDBC Connection object

Returns:

a Java OffsetDateTime

Throws:

SQLException

dateValue

public Date dateValue(Connection conn)
               throws SQLException

Calls toDate to convert internal Oracle TIMESTAMPTZ to a Java Date.

Parameters:

a - JDBC Connection object

Returns:

a Java Date

Throws:

SQLException

timeValue

public Time timeValue(Connection conn)
               throws SQLException

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

Returns:

a Java Time value

Throws:

SQLException

getTimeZone

public TimeZone getTimeZone()
                     throws SQLException

Returns:

the TimeZone of this value

Throws:

SQLException

of

public static TIMESTAMPTZ of(java.time.ZonedDateTime zdt)
                      throws SQLException

Creates TIMESTAMPTZ from the LocalDateTime.

Parameters:

zdt - ZonedDateTime object

Returns:

TIMESTAMPTZ object

Throws:

SQLException

toZonedDateTime

public java.time.ZonedDateTime toZonedDateTime()
                                        throws SQLException

Converts TIMESTAMPTZ to ZonedDateTime.

Returns:

ZonedDateTime object.

Throws:

SQLException

of

public static TIMESTAMPTZ of(java.time.OffsetDateTime odt)
                      throws SQLException

Creates TIMESTAMPTZ from the OffsetDateTime.

Parameters:

odt - OffsetDateTime object

Returns:

TIMESTAMPTZ object

Throws:

SQLException

toOffsetDateTime

public java.time.OffsetDateTime toOffsetDateTime()
                                          throws SQLException

Converts TIMESTAMPTZ to OffsetDateTime.

Returns:

OffsetDateTime object.

Throws:

SQLException

toJdbc

public Object toJdbc()
              throws SQLException

Returns the JDBC representation of the timestamptz object

Specified by:

toJdbc in class Datum

Returns:

an object containing the JDBC value

Throws:

SQLException - if conversion to JDBC representation results in an error

makeJdbcArray

public 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(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

</section>