Skip navigation links

Oracle® Database JDBC Java API Reference
11g Release 2

E13995-02


oracle.sql
Class TIMESTAMPTZ

java.lang.Object
  extended by oracle.sql.Datum
      extended by oracle.sql.TIMESTAMPTZ

All Implemented Interfaces:
java.io.Serializable

public class TIMESTAMPTZ
extends Datum

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.

Since:
release specific (what release of product did this appear in)
See Also:
Serialized Form

Field Summary
static java.lang.String BUILD_DATE
           
static boolean PRIVATE_TRACE
           
static boolean TRACE
           

 

Constructor Summary
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(java.sql.Connection conn, java.sql.Date date)
          Create an Oracle TIMESTAMPTZ object represented by the java Date
TIMESTAMPTZ(java.sql.Connection conn, DATE date)
          Create an Oracle TIMESTAMPTZ object represented by the Oracle date
TIMESTAMPTZ(java.sql.Connection conn, java.sql.Date date, java.util.Calendar cal)
          Create an Oracle TIMESTAMPTZ object represented by the java Date and the java Calendar object
TIMESTAMPTZ(java.sql.Connection conn, java.lang.String str)
          Create a TIMESTAMPTZ object given a Java String object.
TIMESTAMPTZ(java.sql.Connection conn, java.lang.String str, java.util.Calendar cal)
          Create a TIMESTAMPTZ object given a Java String object.
TIMESTAMPTZ(java.sql.Connection conn, java.sql.Time time)
          Create an Oracle TIMESTAMPTZ object represented by the given java Time
TIMESTAMPTZ(java.sql.Connection conn, java.sql.Time time, java.util.Calendar cal)
          Create an Oracle TIMESTAMPTZ object represented by the given java Time and the java Calendar object
TIMESTAMPTZ(java.sql.Connection conn, java.sql.Timestamp timestamp)
          Create an Oracle TIMESTAMPTZ object represented by the java Timestamp
TIMESTAMPTZ(java.sql.Connection conn, java.sql.Timestamp timestamp, java.util.Calendar cal)
          Create an Oracle TIMESTAMPTZ object represented by the java Timestamp and the java Calendar object

 

Method Summary
 java.sql.Date dateValue(java.sql.Connection conn)
          Calls toDate to convert internal Oracle TIMESTAMPTZ to a Java Date.
 boolean isConvertibleTo(java.lang.Class cls)
          Determines if the object can be converted to a particular class
 java.lang.Object makeJdbcArray(int arraySize)
          Returns a JDBC array representation of the datum
 java.lang.String stringValue(java.sql.Connection conn)
          Calls toString to convert internal Oracle TIMESTAMPTZ to a Java String.
 java.sql.Timestamp timestampValue(java.sql.Connection conn)
          Calls toTimestamp to convert internal Oracle Date to a Java Timestamp.
 java.sql.Time timeValue(java.sql.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(java.sql.Connection conn, java.sql.Date date)
          Convert Java Date to Oracle TIMESTAMPTZ.
static byte[] toBytes(java.sql.Connection conn, DATE date)
          Convert Oracle DATE to Oracle TIMESTAMPTZ
static byte[] toBytes(java.sql.Connection conn, java.sql.Date date, java.util.Calendar cal)
          Convert Java Date to Oracle TIMESTAMPTZ.
static byte[] toBytes(java.sql.Connection conn, java.lang.String str)
          Convert Java String to Oracle TIMESTAMPTZ.
static byte[] toBytes(java.sql.Connection conn, java.lang.String str, java.util.Calendar cal)
          Convert Java String to Oracle TIMESTAMPTZ.
static byte[] toBytes(java.sql.Connection conn, java.sql.Time time)
          Convert Java Time to Oracle TIMESTAMPTZ.
static byte[] toBytes(java.sql.Connection conn, java.sql.Time time, java.util.Calendar cal)
          Convert Java Time to Oracle TIMESTAMPTZ.
static byte[] toBytes(java.sql.Connection conn, java.sql.Timestamp timestamp)
          Convert Java Timestamp to Oracle TIMESTAMPTZ
static byte[] toBytes(java.sql.Connection conn, java.sql.Timestamp timestamp, java.util.Calendar cal)
          Convert Java Timestamp to Oracle TIMESTAMPTZ
static java.sql.Date toDate(java.sql.Connection conn, byte[] timestamptz)
          Convert a byte array representing a TIMESTAMPTZ object to a Java Date Object
static DATE toDATE(java.sql.Connection conn, byte[] timestamptz)
          Convert a byte array representing a TIMESTAMPTZ object to a Oracle Date Object
static java.sql.Date toDate2(java.sql.Connection conn, byte[] timestamptz)
          Convert a byte array representing a TIMESTAMPTZ object to a Java Date Object in accordance with java.sql.Date specification.
 java.lang.Object toJdbc()
          Returns the JDBC representation of the timestamptz object
static java.lang.String toString(java.sql.Connection conn, byte[] timestamptz)
          Converts a TIMESTAMP to a string
static java.sql.Time toTime(java.sql.Connection conn, byte[] timestamptz)
          Convert a byte array representing a TIMESTAMPTZ object to a Java Time Object
static java.sql.Timestamp toTimestamp(java.sql.Connection conn, byte[] timestamptz)
          Convert a byte array representing a TIMESTAMP object to a Java Timestamp Object
static java.sql.Timestamp toTimestamp2(java.sql.Connection conn, byte[] timestamptz)
          Convert a byte array representing a TIMESTAMP object to a Java Timestamp Object

 

Methods inherited from class oracle.sql.Datum
asciiStreamValue, bigDecimalValue, binaryStreamValue, booleanValue, byteValue, characterStreamValue, dateValue, doubleValue, equals, floatValue, getBytes, getLength, getStream, intValue, longValue, setBytes, setShareBytes, shareBytes, stringValue, timestampValue, timeValue

 

Methods inherited from class java.lang.Object
getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

 

Field Detail

BUILD_DATE

public static final java.lang.String BUILD_DATE
See Also:
Constant Field Values

TRACE

public static final boolean TRACE
See Also:
Constant Field Values

PRIVATE_TRACE

public static final boolean PRIVATE_TRACE
See Also:
Constant Field Values

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(java.sql.Connection conn,
                   java.sql.Date date)
            throws java.sql.SQLException
Create an Oracle TIMESTAMPTZ object represented by the java Date
Parameters:
conn - JDBC connection date Java Date object
Throws:
java.sql.SQLException

TIMESTAMPTZ

public TIMESTAMPTZ(java.sql.Connection conn,
                   java.sql.Date date,
                   java.util.Calendar cal)
            throws java.sql.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:
java.sql.SQLException

TIMESTAMPTZ

public TIMESTAMPTZ(java.sql.Connection conn,
                   java.sql.Time time)
            throws java.sql.SQLException
Create an Oracle TIMESTAMPTZ object represented by the given java Time
Parameters:
conn - JDBC connection time Java Time object
Throws:
java.sql.SQLException

TIMESTAMPTZ

public TIMESTAMPTZ(java.sql.Connection conn,
                   java.sql.Time time,
                   java.util.Calendar cal)
            throws java.sql.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:
java.sql.SQLException

TIMESTAMPTZ

public TIMESTAMPTZ(java.sql.Connection conn,
                   java.sql.Timestamp timestamp)
            throws java.sql.SQLException
Create an Oracle TIMESTAMPTZ object represented by the java Timestamp
Parameters:
conn - JDBC connection timestamp Java Timestamp object
Throws:
java.sql.SQLException

TIMESTAMPTZ

public TIMESTAMPTZ(java.sql.Connection conn,
                   java.sql.Timestamp timestamp,
                   java.util.Calendar cal)
            throws java.sql.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:
java.sql.SQLException

TIMESTAMPTZ

public TIMESTAMPTZ(java.sql.Connection conn,
                   DATE date)
            throws java.sql.SQLException
Create an Oracle TIMESTAMPTZ object represented by the Oracle date
Parameters:
conn - JDBC connection date Oracle DATE object
Throws:
java.sql.SQLException

TIMESTAMPTZ

public TIMESTAMPTZ(java.sql.Connection conn,
                   java.lang.String str)
            throws java.sql.SQLException
Create a TIMESTAMPTZ object given a Java String object.
Parameters:
conn - JDBC connection str Java String object
Throws:
java.sql.SQLException

TIMESTAMPTZ

public TIMESTAMPTZ(java.sql.Connection conn,
                   java.lang.String str,
                   java.util.Calendar cal)
            throws java.sql.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:
java.sql.SQLException

Method Detail

toDate

public static java.sql.Date toDate(java.sql.Connection conn,
                                   byte[] timestamptz)
                            throws java.sql.SQLException
Convert a byte array representing a TIMESTAMPTZ object to a Java Date Object
Parameters:
conn - JDBC connection timestamptz Oracle TIMESTAMPTZ object
Throws:
java.sql.SQLException

toDate2

public static java.sql.Date toDate2(java.sql.Connection conn,
                                    byte[] timestamptz)
                             throws java.sql.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
Throws:
java.sql.SQLException

toTime

public static java.sql.Time toTime(java.sql.Connection conn,
                                   byte[] timestamptz)
                            throws java.sql.SQLException
Convert a byte array representing a TIMESTAMPTZ object to a Java Time Object
Parameters:
conn - JDBC connection timestamptz Oracle TIMESTAMPTZ object
Throws:
java.sql.SQLException

toDATE

public static DATE toDATE(java.sql.Connection conn,
                          byte[] timestamptz)
                   throws java.sql.SQLException
Convert a byte array representing a TIMESTAMPTZ object to a Oracle Date Object
Parameters:
conn - JDBC connection timestamptz Oracle TIMESTAMPTZ object
Throws:
java.sql.SQLException

toTimestamp

public static java.sql.Timestamp toTimestamp(java.sql.Connection conn,
                                             byte[] timestamptz)
                                      throws java.sql.SQLException
Convert a byte array representing a TIMESTAMP object to a Java Timestamp Object
Parameters:
conn - JDBC connection timestamp Oracle TIMESTAMP object
Throws:
java.sql.SQLException

toTimestamp2

public static java.sql.Timestamp toTimestamp2(java.sql.Connection conn,
                                              byte[] timestamptz)
                                       throws java.sql.SQLException
Convert a byte array representing a TIMESTAMP object to a Java Timestamp Object
Parameters:
conn - JDBC connection timestamp Oracle TIMESTAMP object
Throws:
java.sql.SQLException

toString

public static java.lang.String toString(java.sql.Connection conn,
                                        byte[] timestamptz)
                                 throws java.sql.SQLException
Converts a TIMESTAMP to a string
Parameters:
timestamptz - a byte array
Returns:
String representing the date
Throws:
java.sql.SQLException

timestampValue

public java.sql.Timestamp timestampValue(java.sql.Connection conn)
                                  throws java.sql.SQLException
Calls toTimestamp to convert internal Oracle Date to a Java Timestamp.
Returns:
a Java Timestamp value
Throws:
java.sql.SQLException

toBytes

public byte[] toBytes()
Convert Oracle Timestamptz object into a byte array
Returns:
the byte array stored in the TIMESTAMPTZ object

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.sql.Date date)
                      throws java.sql.SQLException
Convert Java Date to Oracle TIMESTAMPTZ.
Parameters:
conn - JDBC connection date Java Date object
Returns:
the byte array representing the java Date.
Throws:
java.sql.SQLException

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.sql.Date date,
                             java.util.Calendar cal)
                      throws java.sql.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:
java.sql.SQLException

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.sql.Time time)
                      throws java.sql.SQLException
Convert Java Time to Oracle TIMESTAMPTZ.
Parameters:
conn - JDBC connection time Java Time object
Returns:
the byte array representing the java Time.
Throws:
java.sql.SQLException

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.sql.Time time,
                             java.util.Calendar cal)
                      throws java.sql.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:
java.sql.SQLException

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.sql.Timestamp timestamp)
                      throws java.sql.SQLException
Convert Java Timestamp to Oracle TIMESTAMPTZ
Parameters:
conn - JDBC connection timestamp Java Timestamp object
Returns:
the byte array representing the TIMESTAMPTZ object.
Throws:
java.sql.SQLException

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.sql.Timestamp timestamp,
                             java.util.Calendar cal)
                      throws java.sql.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:
java.sql.SQLException

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             DATE date)
                      throws java.sql.SQLException
Convert Oracle DATE to Oracle TIMESTAMPTZ
Parameters:
conn - JDBC connection date Oracle DATE object
Returns:
the byte array representing the Oracle TIMESTAMPTZ.
Throws:
java.sql.SQLException

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.lang.String str)
                      throws java.sql.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:
java.sql.SQLException

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.lang.String str,
                             java.util.Calendar cal)
                      throws java.sql.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:
java.sql.SQLException

stringValue

public java.lang.String stringValue(java.sql.Connection conn)
                             throws java.sql.SQLException
Calls toString to convert internal Oracle TIMESTAMPTZ to a Java String.
Parameters:
conn - oracle.JDBC.OracleConnection object
Returns:
a Java String value
Throws:
java.sql.SQLException

dateValue

public java.sql.Date dateValue(java.sql.Connection conn)
                        throws java.sql.SQLException
Calls toDate to convert internal Oracle TIMESTAMPTZ to a Java Date.
Parameters:
a - JDBC Connection object
Returns:
a Java Date
Throws:
java.sql.SQLException

timeValue

public java.sql.Time timeValue(java.sql.Connection conn)
                        throws java.sql.SQLException
Calls toTime to convert internal Oracle Date 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 timestamptz 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

Skip navigation links

Oracle® Database JDBC Java API Reference
11g Release 2

E13995-02


Copyright © 2009, Oracle and/or its affiliates. All rights reserved.