TIMESTAMPTZ (Oracle Database JDBC Java API Reference)

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

Field Summary
- Fields inherited from class oracle.sql.Datum
  ojiOracleDatumWithConnection, targetDatum

Constructor Summary

Constructors
Constructor and 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, Date date)` Create an Oracle TIMESTAMPTZ object represented by the Java Date
`TIMESTAMPTZ(Connection conn, DATE date)` Create an Oracle TIMESTAMPTZ object represented by the Oracle 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, 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, 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, Calendar cal)` Create an Oracle TIMESTAMPTZ object represented by the Java Timestamp and the Java Calendar object
`TIMESTAMPTZ(Connection conn, Timestamp timestamp, java.time.ZoneId tzid)` Create an Oracle TIMESTAMPTZ object represented by the Java Timestamp with the specified ZoneId.

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and 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
`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, Date date)` Convert Java Date to Oracle TIMESTAMPTZ.
`static byte[]`	`toBytes(Connection conn, DATE date)` Convert Oracle DATE to Oracle TIMESTAMPTZ
`static byte[]`	`toBytes(Connection conn, Date date, Calendar cal)` Convert Java Date to Oracle TIMESTAMPTZ.
`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, 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, Calendar cal)` Convert Java Timestamp to Oracle TIMESTAMPTZ
`static byte[]`	`toBytes(Connection conn, Timestamp timestamp, java.time.ZoneId tzid)` Convert Java Timestamp 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
`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

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

Methods inherited from interface oracle.jdbc.internal.OracleTimestampWithTimeZone
from, from

- 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
- 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
    
    Specified by:
    
    toTimestamp in interface oracle.jdbc.internal.OracleTimestampWithTimeZone
    
    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
    
    Specified by:
    
    toString in interface oracle.jdbc.internal.OracleTimestampWithTimeZone
    
    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.
    
    Specified by:
    
    toBytes in interface oracle.jdbc.internal.OracleTimestampWithTimeZone
    
    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
  - 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

Class TIMESTAMPTZ

Field Summary

Fields inherited from class oracle.sql.Datum

Constructor Summary

Method Summary

Methods inherited from class oracle.sql.Datum

Methods inherited from class java.lang.Object

Methods inherited from interface oracle.jdbc.internal.OracleTimestampWithTimeZone

Constructor Detail

TIMESTAMPTZ

TIMESTAMPTZ

TIMESTAMPTZ

TIMESTAMPTZ

TIMESTAMPTZ

TIMESTAMPTZ

TIMESTAMPTZ

TIMESTAMPTZ

TIMESTAMPTZ

TIMESTAMPTZ

TIMESTAMPTZ

TIMESTAMPTZ

Method Detail

toDate

toDate2

toTime

toDATE

toTIMESTAMP

toTimestamp

toTimestamp2

toString

toOffsetDateTime

timestampValue

toBytes

toBytes

toBytes

toBytes

toBytes

toBytes

toBytes

toBytes

toBytes

toBytes

toBytes

stringValue

offsetDateTimeValue

dateValue

timeValue

getTimeZone

toJdbc

makeJdbcArray

isConvertibleTo