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.sql.Date date, java.util.Calendar dbtz)
          Create an Oracle TIMESTAMPLTZ object represented by the java Date
TIMESTAMPLTZ(java.sql.Connection conn, DATE date, java.util.Calendar dbtz)
          Create an Oracle TIMESTAMPLTZ object represented by the Oracle date
TIMESTAMPLTZ(java.sql.Connection conn, java.sql.Time time, java.util.Calendar dbtz)
          Create an Oracle TIMESTAMPLTZ object represented by the given java Time
TIMESTAMPLTZ(java.sql.Connection conn, java.sql.Timestamp timestamp, java.util.Calendar dbtz)
          Create an Oracle TIMESTAMPLTZ object represented by the java Timestamp
 
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.sql.Date date, java.util.Calendar dbtz)
          Convert Java Date to Oracle TIMESTAMPLTZ.
static byte[] toBytes(java.sql.Connection conn, DATE date, java.util.Calendar dbtz)
          Convert Oracle DATE to Oracle Timestampltz
static byte[] toBytes(java.sql.Connection conn, java.sql.Time time, java.util.Calendar dbtz)
          Convert Java Time to Oracle TIMESTAMPLTZ.
static byte[] toBytes(java.sql.Connection conn, java.sql.Timestamp timestamp, java.util.Calendar dbtz)
          Convert Java Timestamp to Oracle TIMESTAMPLTZ
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, java.util.Calendar dbtz)
          Converts a TIMESTAMP to a string
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, 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
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
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
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
Create an Oracle TIMESTAMPLTZ object represented by the Oracle date
Parameters:
conn - JDBC connection date Oracle DATE object dbtz Calendar object containing Database Timezone
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
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
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
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
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
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.

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