oracle.sql
Class TIMESTAMPLTZ

java.lang.Object
  |
  +--oracle.sql.Datum
        |
        +--oracle.sql.TIMESTAMPLTZ
public class TIMESTAMPLTZ
extends Datum

TIMESTAMPLTZ Class


The TIMESTAMPLTZ 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 eleven 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)
-We add 100 to the century and decade fields so that negative values will be positive and positive values will be higher than negative values -We add 1 to the month,hour,minute,second fields for the java objects since they start of from 0.

Static methods are used for conversions.

Since:
release specific (what release of product did this appear in)

Constructor Summary
TIMESTAMPLTZ()
          Constructs a TIMESTAMPLTZ object initialized to 1/1/1970.
TIMESTAMPLTZ(byte[] timestampltz)
          Create an Oracle TIMESTAMPLTZ object represented by the given Oracle Timestampltz
TIMESTAMPLTZ(java.sql.Connection conn, java.util.Calendar sess, java.sql.Date date)
          Create an Oracle TIMESTAMPLTZ object represented by the java Date
TIMESTAMPLTZ(java.sql.Connection conn, java.util.Calendar sess, DATE date)
          Create an Oracle TIMESTAMPLTZ object represented by the Oracle date
TIMESTAMPLTZ(java.sql.Connection conn, java.util.Calendar sess, java.lang.String str)
          Deprecated.  
TIMESTAMPLTZ(java.sql.Connection conn, java.util.Calendar sess, java.sql.Time time)
          Create an Oracle TIMESTAMPLTZ object represented by the given java Time
TIMESTAMPLTZ(java.sql.Connection conn, java.util.Calendar sess, java.sql.Timestamp timestamp)
          Create an Oracle TIMESTAMPLTZ object represented by the java Timestamp
TIMESTAMPLTZ(java.sql.Connection conn, java.sql.Date date)
          Create an Oracle TIMESTAMPLTZ object represented by the java Date
TIMESTAMPLTZ(java.sql.Connection conn, DATE date)
          Create an Oracle TIMESTAMPLTZ object represented by the Oracle date
TIMESTAMPLTZ(java.sql.Connection conn, java.sql.Date date, java.util.Calendar dbtz)
          Deprecated.  
TIMESTAMPLTZ(java.sql.Connection conn, DATE date, java.util.Calendar dbtz)
          Deprecated.  
TIMESTAMPLTZ(java.sql.Connection conn, java.lang.String str)
          Deprecated.  
TIMESTAMPLTZ(java.sql.Connection conn, java.lang.String str, java.util.Calendar dbtz)
          Deprecated.  
TIMESTAMPLTZ(java.sql.Connection conn, java.sql.Time time)
          Create an Oracle TIMESTAMPLTZ object represented by the given java Time
TIMESTAMPLTZ(java.sql.Connection conn, java.sql.Time time, java.util.Calendar dbtz)
          Deprecated.  
TIMESTAMPLTZ(java.sql.Connection conn, java.sql.Timestamp timestamp)
          Create an Oracle TIMESTAMPLTZ object represented by the java Timestamp
TIMESTAMPLTZ(java.sql.Connection conn, java.sql.Timestamp timestamp, java.util.Calendar dbtz)
          Deprecated.  
 
Method Summary
 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, java.util.Calendar dbtz)
          Calls toTimestamp to convert internal Oracle Date to a Java Timestamp.
 byte[] toBytes()
          Convert Oracle Timestampltz object into a byte array
static byte[] toBytes(java.sql.Connection conn, java.util.Calendar cal, java.sql.Date date)
          Convert Java Date to Oracle TIMESTAMPLTZ.
static byte[] toBytes(java.sql.Connection conn, java.util.Calendar cal, DATE date)
          Convert Oracle DATE to Oracle Timestampltz
static byte[] toBytes(java.sql.Connection conn, java.util.Calendar sess, java.lang.String str)
          Convert Java String to Oracle TIMESTAMPLTZ.
static byte[] toBytes(java.sql.Connection conn, java.util.Calendar cal, java.sql.Time time)
          Convert Java Time to Oracle TIMESTAMPLTZ.
static byte[] toBytes(java.sql.Connection conn, java.util.Calendar cal, java.sql.Timestamp timestamp)
          Convert Java Timestamp to Oracle TIMESTAMPLTZ
static byte[] toBytes(java.sql.Connection conn, java.sql.Date date, java.util.Calendar dbtz)
          Deprecated.  
static byte[] toBytes(java.sql.Connection conn, DATE date, java.util.Calendar dbtz)
          Deprecated.  
static byte[] toBytes(java.sql.Connection conn, java.lang.String str, java.util.Calendar dbtz)
          Convert Java String to Oracle TIMESTAMPLTZ.
static byte[] toBytes(java.sql.Connection conn, java.sql.Time time, java.util.Calendar dbtz)
          Deprecated.  
static byte[] toBytes(java.sql.Connection conn, java.sql.Timestamp timestamp, java.util.Calendar dbtz)
          Deprecated.  
static java.sql.Date toDate(java.sql.Connection conn, byte[] timestamp)
          Convert a byte array representing a TIMESTAMPLTZ object to a Java Date Object
static DATE toDATE(java.sql.Connection conn, byte[] timestamp)
          Convert a byte array representing a TIMESTAMPLTZ object to a Oracle Date Object
static java.sql.Date toDate(java.sql.Connection conn, byte[] timestamp, java.util.Calendar dbtz)
          Convert a byte array representing a TIMESTAMPLTZ object to a Java Date Object
static DATE toDATE(java.sql.Connection conn, byte[] timestamp, java.util.Calendar dbtz)
          Convert a byte array representing a TIMESTAMPLTZ object to a Oracle Date Object
 java.lang.Object toJdbc()
          Returns the JDBC representation of the datum object
static java.lang.String toString(java.sql.Connection conn, byte[] timestamp)
          Converts a TIMESTAMP to a string
static java.lang.String toString(java.sql.Connection conn, byte[] timestamp, java.util.Calendar dbtz)
          Deprecated.  
static java.sql.Time toTime(java.sql.Connection conn, byte[] timestamp)
          Convert a byte array representing a TIMESTAMPLTZ object to a Java Time Object
static java.sql.Time toTime(java.sql.Connection conn, byte[] timestamp, java.util.Calendar dbtz)
          Convert a byte array representing a TIMESTAMPLTZ 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 toTimestamp(java.sql.Connection conn, byte[] timestamptz, java.util.Calendar dbtz)
          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

TIMESTAMPLTZ

public TIMESTAMPLTZ()
Constructs a TIMESTAMPLTZ object initialized to 1/1/1970.

TIMESTAMPLTZ

public TIMESTAMPLTZ(byte[] timestampltz)
Create an Oracle TIMESTAMPLTZ object represented by the given Oracle Timestampltz
Parameters:
Connection - conn

TIMESTAMPLTZ

public TIMESTAMPLTZ(java.sql.Connection conn,
                    java.sql.Time time,
                    java.util.Calendar dbtz)
             throws java.sql.SQLException
Deprecated.  
Create an Oracle TIMESTAMPLTZ object represented by the given java Time
Parameters:
conn - JDBC connection time Java Time object dbtz Calendar object containing Database Timezone

TIMESTAMPLTZ

public TIMESTAMPLTZ(java.sql.Connection conn,
                    java.sql.Date date,
                    java.util.Calendar dbtz)
             throws java.sql.SQLException
Deprecated.  
Create an Oracle TIMESTAMPLTZ object represented by the java Date
Parameters:
conn - JDBC connection date Java Date object dbtz Calendar object containing Database Timezone

TIMESTAMPLTZ

public TIMESTAMPLTZ(java.sql.Connection conn,
                    java.sql.Timestamp timestamp,
                    java.util.Calendar dbtz)
             throws java.sql.SQLException
Deprecated.  
Create an Oracle TIMESTAMPLTZ object represented by the java Timestamp
Parameters:
conn - Connection timestamp Java Timestamp object dbtz Calendar object containing Database Timezone

TIMESTAMPLTZ

public TIMESTAMPLTZ(java.sql.Connection conn,
                    DATE date,
                    java.util.Calendar dbtz)
             throws java.sql.SQLException
Deprecated.  
Create an Oracle TIMESTAMPLTZ object represented by the Oracle date
Parameters:
conn - JDBC connection date Oracle DATE object dbtz Calendar object containing Database Timezone

TIMESTAMPLTZ

public TIMESTAMPLTZ(java.sql.Connection conn,
                    java.lang.String str,
                    java.util.Calendar dbtz)
             throws java.sql.SQLException
Deprecated.  
Create a TIMESTAMPLTZ object given a Java String object.
Parameters:
conn - JDBC connection str Java String object dbtz Calendar object containing Database Timezone

TIMESTAMPLTZ

public TIMESTAMPLTZ(java.sql.Connection conn,
                    java.util.Calendar sess,
                    java.sql.Time time)
             throws java.sql.SQLException
Create an Oracle TIMESTAMPLTZ object represented by the given java Time
Parameters:
conn - JDBC connection sess Calendar object containing Session Timezone time Java Time object

TIMESTAMPLTZ

public TIMESTAMPLTZ(java.sql.Connection conn,
                    java.util.Calendar sess,
                    java.sql.Date date)
             throws java.sql.SQLException
Create an Oracle TIMESTAMPLTZ object represented by the java Date
Parameters:
conn - JDBC connection sess Calendar object containing Session Timezone date Java Date object

TIMESTAMPLTZ

public TIMESTAMPLTZ(java.sql.Connection conn,
                    java.util.Calendar sess,
                    java.sql.Timestamp timestamp)
             throws java.sql.SQLException
Create an Oracle TIMESTAMPLTZ object represented by the java Timestamp
Parameters:
conn - Connection sess Calendar object containing Session Timezone timestamp Java Timestamp object

TIMESTAMPLTZ

public TIMESTAMPLTZ(java.sql.Connection conn,
                    java.util.Calendar sess,
                    DATE date)
             throws java.sql.SQLException
Create an Oracle TIMESTAMPLTZ object represented by the Oracle date
Parameters:
conn - JDBC connection sess Calendar object containing Session Timezone date Oracle DATE object

TIMESTAMPLTZ

public TIMESTAMPLTZ(java.sql.Connection conn,
                    java.util.Calendar sess,
                    java.lang.String str)
             throws java.sql.SQLException
Deprecated.  
Create a TIMESTAMPLTZ object given a Java String object.
Parameters:
conn - JDBC connection sess Calendar object containing Session Timezone str Java String object

TIMESTAMPLTZ

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

TIMESTAMPLTZ

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

TIMESTAMPLTZ

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

TIMESTAMPLTZ

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

TIMESTAMPLTZ

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

toDate

public static java.sql.Date toDate(java.sql.Connection conn,
                                   byte[] timestamp,
                                   java.util.Calendar dbtz)
                            throws java.sql.SQLException
Convert a byte array representing a TIMESTAMPLTZ object to a Java Date Object

toTime

public static java.sql.Time toTime(java.sql.Connection conn,
                                   byte[] timestamp,
                                   java.util.Calendar dbtz)
                            throws java.sql.SQLException
Convert a byte array representing a TIMESTAMPLTZ object to a Java Time Object

toTimestamp

public static java.sql.Timestamp toTimestamp(java.sql.Connection conn,
                                             byte[] timestamptz,
                                             java.util.Calendar dbtz)
                                      throws java.sql.SQLException
Convert a byte array representing a TIMESTAMP object to a Java Timestamp Object

toDATE

public static DATE toDATE(java.sql.Connection conn,
                          byte[] timestamp,
                          java.util.Calendar dbtz)
                   throws java.sql.SQLException
Convert a byte array representing a TIMESTAMPLTZ object to a Oracle Date Object

timestampValue

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

toString

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

toBytes

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

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.sql.Time time,
                             java.util.Calendar dbtz)
                      throws java.sql.SQLException
Deprecated.  
Convert Java Time to Oracle TIMESTAMPLTZ.
Parameters:
conn - JDBC connection time java.sql.Time object to be converted. dbtz Database timezone
Returns:
the byte array representing the java Time.

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.sql.Date date,
                             java.util.Calendar dbtz)
                      throws java.sql.SQLException
Deprecated.  
Convert Java Date to Oracle TIMESTAMPLTZ.
Parameters:
conn - JDBC connection date java.sql.Date object to be converted. dbtz Database timezone
Returns:
the byte array representing the java Date.

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.sql.Timestamp timestamp,
                             java.util.Calendar dbtz)
                      throws java.sql.SQLException
Deprecated.  
Convert Java Timestamp to Oracle TIMESTAMPLTZ
Parameters:
conn - JDBC connection Timestamp java.sql.Timestamp object to be converted. dbtz database timezone
Returns:
the byte array representing the input date.

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             DATE date,
                             java.util.Calendar dbtz)
                      throws java.sql.SQLException
Deprecated.  
Convert Oracle DATE to Oracle Timestampltz
Parameters:
conn - JDBC connection date oracle.sql.Timestampltz object to be converted. dbtz database timezone
Returns:
the byte array representing the oracle DATE.

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.lang.String str,
                             java.util.Calendar dbtz)
                      throws java.sql.SQLException
Convert Java String to Oracle TIMESTAMPLTZ.
Parameters:
conn - JDBC Connection str java.lang.String object to be converted. dbtz database timezone
Returns:
the byte array representing the input string.

toDate

public static java.sql.Date toDate(java.sql.Connection conn,
                                   byte[] timestamp)
                            throws java.sql.SQLException
Convert a byte array representing a TIMESTAMPLTZ object to a Java Date Object

toTime

public static java.sql.Time toTime(java.sql.Connection conn,
                                   byte[] timestamp)
                            throws java.sql.SQLException
Convert a byte array representing a TIMESTAMPLTZ object to a Java Time 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

toDATE

public static DATE toDATE(java.sql.Connection conn,
                          byte[] timestamp)
                   throws java.sql.SQLException
Convert a byte array representing a TIMESTAMPLTZ object to a Oracle Date Object

toString

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

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.util.Calendar cal,
                             java.sql.Time time)
                      throws java.sql.SQLException
Convert Java Time to Oracle TIMESTAMPLTZ.
Parameters:
conn - JDBC connection cal Session timezone time java.sql.Time object to be converted.
Returns:
the byte array representing the java Time.

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.util.Calendar cal,
                             java.sql.Date date)
                      throws java.sql.SQLException
Convert Java Date to Oracle TIMESTAMPLTZ.
Parameters:
conn - JDBC connection cal Session timezone date java.sql.Date object to be converted.
Returns:
the byte array representing the java Date.

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.util.Calendar cal,
                             java.sql.Timestamp timestamp)
                      throws java.sql.SQLException
Convert Java Timestamp to Oracle TIMESTAMPLTZ
Parameters:
conn - JDBC connection cal Session timezone Timestamp java.sql.Timestamp object to be converted.
Returns:
the byte array representing the input date.

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.util.Calendar cal,
                             DATE date)
                      throws java.sql.SQLException
Convert Oracle DATE to Oracle Timestampltz
Parameters:
conn - JDBC connection cal Session timezone date oracle.sql.Timestampltz object to be converted.
Returns:
the byte array representing the oracle DATE.

toBytes

public static byte[] toBytes(java.sql.Connection conn,
                             java.util.Calendar sess,
                             java.lang.String str)
                      throws java.sql.SQLException
Convert Java String to Oracle TIMESTAMPLTZ.
Parameters:
conn - JDBC Connection sess Calendar object containing Session Timezone str java.lang.String object to be converted.
Returns:
the byte array representing the input string.

toJdbc

public java.lang.Object toJdbc()
                        throws java.sql.SQLException
Returns the JDBC representation of the datum 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