oracle.sql
Class TIMESTAMPTZ

java.lang.Object
  |
  +--oracle.sql.Datum
        |
        +--oracle.sql.TIMESTAMPTZ

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)

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.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

Type	Method
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.sql.Timestamp	timestampValue(java.sql.Connection conn) Calls toTimestamp to convert internal Oracle Date to a Java Timestamp.
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.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
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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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.

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.

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.

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.

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.

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.

toJdbc

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

Returns the JDBC representation of the timestamptz object

Returns:

an object containing the JDBC value

Overrides:

toJdbc in class Datum

makeJdbcArray

public java.lang.Object makeJdbcArray(int arraySize)

Returns a JDBC array representation of the datum

Parameters:

arraySize - size of the array

Returns:

an object containing the JDBC array value

Overrides:

makeJdbcArray in class Datum

isConvertibleTo

public boolean isConvertibleTo(java.lang.Class cls)

Determines if the object can be converted to a particular class

Parameters:

cls - Class to convert to

Returns:

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

Overrides:

isConvertibleTo in class Datum