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, java.time.LocalDateTime ldt)` Create a TIMESTAMPTZ object given a Java LocalDateTime 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.
`TIMESTAMPTZ(java.time.OffsetDateTime odt)` Create a TIMESTAMPTZ object given a Java OffsetDateTime object.
`TIMESTAMPTZ(java.time.OffsetTime ot)` Create a TIMESTAMPTZ object given a Java OffsetTime object.
`TIMESTAMPTZ(java.time.ZonedDateTime zdt)` Create a TIMESTAMPTZ object given a Java ZonedDateTime object.

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
`java.time.LocalDateTime`	`localDateTimeValue()` Calls toLocalDateTime to convert internal Oracle TIMESTAMPTZ to a Java LocalDateTime.
`Object`	`makeJdbcArray(int arraySize)` Returns a JDBC array representation of the datum
`static TIMESTAMPTZ`	`of(Connection conn, java.time.LocalDateTime ldt)` Creates TIMESTAMPTZ from the LocalDateTime.
`static TIMESTAMPTZ`	`of(java.time.OffsetDateTime odt)` Creates TIMESTAMPTZ from the OffsetDateTime.
`static TIMESTAMPTZ`	`of(java.time.ZonedDateTime zdt)` Creates TIMESTAMPTZ from the ZonedDateTime.
`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, java.time.LocalDateTime ldt)` Convert Java LocalDateTime 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 byte[]`	`toBytes(java.time.OffsetDateTime odt)` Convert Java OffsetDateTime to Oracle TIMESTAMPTZ.
`static byte[]`	`toBytes(java.time.OffsetTime ot)` Convert Java OffsetTime to Oracle TIMESTAMPTZ.
`static byte[]`	`toBytes(java.time.ZonedDateTime zdt)` Convert Java ZonedDateTime 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.LocalDateTime`	`toLocalDateTime()` Converts TIMESTAMPTZ to LocalDateTime.
`static java.time.LocalDateTime`	`toLocalDateTime(byte[] timestamptz)` Converts TIMESTAMPTZ to LocalDateTime.
`java.time.OffsetDateTime`	`toOffsetDateTime()` Converts TIMESTAMPTZ to OffsetDateTime.
`static java.time.OffsetDateTime`	`toOffsetDateTime(Connection conn, byte[] timestamptz)` Converts a TIMESTAMPTZ to an OffsetDateTime
`java.time.OffsetTime`	`toOffsetTime()` Converts a TIMESTAMPTZ to an OffsetTime
`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.
`static java.time.ZonedDateTime`	`toZonedDateTime(byte[] timestamptz)` Converts TIMESTAMPTZ to ZonedDateTime.
`java.time.ZonedDateTime`	`zonedDateTimeValue()` Calls toZonedDateTime to convert internal Oracle TIMESTAMPTZ 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

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
  - TIMESTAMPTZ
```
public TIMESTAMPTZ(java.time.OffsetDateTime odt)
            throws SQLException
```
    Create a TIMESTAMPTZ object given a Java OffsetDateTime object.
    
    Parameters:
    
    odt - OffsetDateTime object
    
    Throws:
    
    SQLException
  - TIMESTAMPTZ
```
public TIMESTAMPTZ(java.time.ZonedDateTime zdt)
            throws SQLException
```
    Create a TIMESTAMPTZ object given a Java ZonedDateTime object.
    
    Parameters:
    
    zdt - ZonedDateTime object
    
    Throws:
    
    SQLException
  - TIMESTAMPTZ
```
public TIMESTAMPTZ(Connection conn,
                   java.time.LocalDateTime ldt)
            throws SQLException
```
    Create a TIMESTAMPTZ object given a Java LocalDateTime object.
    
    Parameters:
    
    ldt - LocalDateTime object
    
    Throws:
    
    SQLException
  - TIMESTAMPTZ
```
public TIMESTAMPTZ(java.time.OffsetTime ot)
            throws SQLException
```
    Create a TIMESTAMPTZ object given a Java OffsetTime object.
    
    Parameters:
    
    ot - OffsetTime object
    
    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
  - toBytes
```
public static byte[] toBytes(java.time.OffsetDateTime odt)
                      throws SQLException
```
    Convert Java OffsetDateTime to Oracle TIMESTAMPTZ.
    
    Parameters:
    
    odt - OffsetDateTime object
    
    Returns:
    
    the byte array representing the java Date.
    
    Throws:
    
    SQLException
  - toBytes
```
public static byte[] toBytes(java.time.ZonedDateTime zdt)
                      throws SQLException
```
    Convert Java ZonedDateTime to Oracle TIMESTAMPTZ.
    
    Parameters:
    
    zdt - ZonedDateTime object
    
    Returns:
    
    the byte array representing the java Date.
    
    Throws:
    
    SQLException
  - toBytes
```
public static byte[] toBytes(Connection conn,
                             java.time.LocalDateTime ldt)
                      throws SQLException
```
    Convert Java LocalDateTime to Oracle TIMESTAMPTZ.
    
    Parameters:
    
    zdt - LocalDateTime object
    
    Returns:
    
    the byte array representing the java Date.
    
    Throws:
    
    SQLException
  - toBytes
```
public static byte[] toBytes(java.time.OffsetTime ot)
                      throws SQLException
```
    Convert Java OffsetTime to Oracle TIMESTAMPTZ.
    
    Parameters:
    
    ot - OffsetTime object
    
    Returns:
    
    the byte array representing the java Date.
    
    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
  - zonedDateTimeValue
```
public java.time.ZonedDateTime zonedDateTimeValue()
                                           throws SQLException
```
    Calls toZonedDateTime to convert internal Oracle TIMESTAMPTZ to a Java ZonedDateTime.
    
    Parameters:
    
    a - JDBC Connection object
    
    Returns:
    
    a Java ZonedDateTime
    
    Throws:
    
    SQLException
  - localDateTimeValue
```
public java.time.LocalDateTime localDateTimeValue()
                                           throws SQLException
```
    Calls toLocalDateTime to convert internal Oracle TIMESTAMPTZ to a Java LocalDateTime.
    
    Returns:
    
    a Java LocalDateTime
    
    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 ZonedDateTime.
    
    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
  - toLocalDateTime
```
public java.time.LocalDateTime toLocalDateTime()
                                        throws SQLException
```
    Converts TIMESTAMPTZ to LocalDateTime.
    
    Returns:
    
    LocalDateTime object.
    
    Throws:
    
    SQLException
  - toLocalDateTime
```
public static java.time.LocalDateTime toLocalDateTime(byte[] timestamptz)
                                               throws SQLException
```
    Converts TIMESTAMPTZ to LocalDateTime.
    
    Parameters:
    
    timestamptz - TIMESTAMPTZ datum
    
    Returns:
    
    LocalDateTime object.
    
    Throws:
    
    SQLException
  - toZonedDateTime
```
public static java.time.ZonedDateTime toZonedDateTime(byte[] timestamptz)
                                               throws SQLException
```
    Converts TIMESTAMPTZ to ZonedDateTime.
    
    Returns:
    
    ZonedDateTime object.
    
    Throws:
    
    SQLException
  - toOffsetTime
```
public java.time.OffsetTime toOffsetTime()
                                  throws SQLException
```
    Converts a TIMESTAMPTZ to an OffsetTime
    
    Parameters:
    
    timestamptz - a byte array
    
    Returns:
    
    OffsetTime representing the TIMESTAMPTZ
    
    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
  - of
```
public static TIMESTAMPTZ of(Connection conn,
                             java.time.LocalDateTime ldt)
                      throws SQLException
```
    Creates TIMESTAMPTZ from the LocalDateTime.
    
    Parameters:
    
    conn - Connection object
    
    ldt - LocalDateTime 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

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

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

toBytes

toBytes

toBytes

toBytes

offsetDateTimeValue

zonedDateTimeValue

localDateTimeValue

dateValue

timeValue

getTimeZone

of

toZonedDateTime

toLocalDateTime

toLocalDateTime

toZonedDateTime

toOffsetTime

of

of

toOffsetDateTime

toJdbc

makeJdbcArray

isConvertibleTo