Skip navigation links

oracle.sql
Class TIMESTAMP

java.lang.Object
oracle.sql.Datum
oracle.sql.TIMESTAMP

All Implemented Interfaces:

Serializable

public class TIMESTAMP

extends Datum

implements Serializable

TIMESTAMP Class

The TIMESTAMP 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
       8         Nanoseconds
       9         Nanoseconds
       10        Nanoseconds
  

Static methods are used for conversions.

Since:

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

See Also:

Serialized Form

Field Summary

static int	SIZE_DATE
static int	SIZE_TIMESTAMP
static int	SIZE_TIMESTAMP_NOFRAC
static boolean	TRACE

Constructor Summary

TIMESTAMP()
Constructs a TIMESTAMP object initialized to 1/1/1970.

TIMESTAMP(byte[] timestamp)
Create an Oracle TIMESTAMP object represented by the given Oracle Timestamp

TIMESTAMP(Date date)
Create an Oracle TIMESTAMP object represented by the java Date

TIMESTAMP(DATE date)
Create an Oracle TIMESTAMP object represented by the Oracle date

TIMESTAMP(String str)
Create a TIMESTAMP object given a Java String object.

TIMESTAMP(Time time)
Create an Oracle TIMESTAMP object represented by the given java Time

TIMESTAMP(Timestamp timestamp)
Create an Oracle TIMESTAMP object represented by the java Timestamp

TIMESTAMP(Timestamp timestamp, Calendar cal)
Create an Oracle TIMESTAMP object represented by the java Timestamp and Calendar

Method Summary

Date	dateValue() Calls toDate to convert internal Oracle TIMESTAMP to a Java Date.
static int	getJavaYear(int cent, int decade)
static int	getOracleYear(Calendar cal)
boolean	isConvertibleTo(Class cls) Determines if the object can be converted to a particular class
Object	makeJdbcArray(int arraySize) Returns a JDBC array representation of the datum
String	stringValue() Calls toString to convert internal Oracle TIMESTAMP to a Java String.
Timestamp	timestampValue() Calls toTimestamp to convert internal Oracle Date to a Java Timestamp.
Timestamp	timestampValue(Calendar cal) Calls toTimestamp to convert internal Oracle Date and Calendar to a Java Timestamp.
Time	timeValue() Calls toTime to convert internal Oracle Date to a Java Time.
static TIMESTAMP	TimeZoneConvert(Connection conn, TIMESTAMP tstamp, TimeZone tz1, TimeZone tz2) Converts the TIMESTAMP object from one timezone to the other
byte[]	toBytes() Convert Oracle Timestamp object into a byte array
static byte[]	toBytes(Date date) Convert Java Date to Oracle TIMESTAMP.
static byte[]	toBytes(DATE date) Convert Oracle DATE to Oracle Timestamp
static byte[]	toBytes(String str) Convert Java String to Oracle TIMESTAMP.
static byte[]	toBytes(Time time) Convert Java Time to Oracle TIMESTAMP.
static byte[]	toBytes(Timestamp timestamp) Convert Java Timestamp to Oracle Timestamp
static byte[]	toBytes(Timestamp timestamp, Calendar cal) Convert Java Timestamp and Java Calendar to Oracle Timestamp
static Date	toDate(byte[] timestamp) Convert a byte array representing a TIMESTAMP object to a Java Date Object
static DATE	toDATE(byte[] timestamp) Convert a byte array representing a TIMESTAMP object to a Oracle Date Object
Object	toJdbc() Returns the JDBC representation of the datum object
String	toString()
static String	toString(byte[] bytes) Converts a TIMESTAMP to a string
static Time	toTime(byte[] timestamp) Convert a byte array representing a TIMESTAMP object to a Java Time Object
static Timestamp	toTimestamp(byte[] timestamp) Convert a byte array representing a TIMESTAMP object to a Java Timestamp Object
static Timestamp	toTimestamp(byte[] timestamp, Calendar cal) Convert a byte array representing a TIMESTAMP object to a Java Timestamp Object given Calendar object

Methods inherited from class oracle.sql.Datum

asciiStreamValue, bigDecimalValue, binaryStreamValue, booleanValue, bytesEqual, byteValue, characterStreamValue, compareBytes, doubleValue, equals, floatValue, getBytes, getConnectionDuringExceptionHandling, getLength, getStream, intValue, isNull, longValue, setBytes, setShareBytes, shareBytes, stringValue, timeValue, toClass

Methods inherited from class java.lang.Object

clone, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

SIZE_DATE

public static final int SIZE_DATE

See Also:

Constant Field Values

SIZE_TIMESTAMP

public static final int SIZE_TIMESTAMP

See Also:

Constant Field Values

SIZE_TIMESTAMP_NOFRAC

public static final int SIZE_TIMESTAMP_NOFRAC

See Also:

Constant Field Values

TRACE

public static final boolean TRACE

See Also:

Constant Field Values

Constructor Detail

TIMESTAMP

public TIMESTAMP()

Constructs a TIMESTAMP object initialized to 1/1/1970.

TIMESTAMP

public TIMESTAMP(byte[] timestamp)

Create an Oracle TIMESTAMP object represented by the given Oracle Timestamp

Parameters:

timestamp - Oracle TIMESTAMP

TIMESTAMP

public TIMESTAMP(Time time)

Create an Oracle TIMESTAMP object represented by the given java Time

Parameters:

time - Java Time object

TIMESTAMP

public TIMESTAMP(Date date)

Create an Oracle TIMESTAMP object represented by the java Date

Parameters:

date - Java Date object

TIMESTAMP

public TIMESTAMP(Timestamp timestamp)

Create an Oracle TIMESTAMP object represented by the java Timestamp

Parameters:

timestamp - Java Timestamp object

TIMESTAMP

public TIMESTAMP(Timestamp timestamp,
                 Calendar cal)

Create an Oracle TIMESTAMP object represented by the java Timestamp and Calendar

Parameters:

timestamp - Java Timestamp object

cal - Java Util Calendar object

TIMESTAMP

public TIMESTAMP(DATE date)

Create an Oracle TIMESTAMP object represented by the Oracle date

Parameters:

date - Oracle DATE object

TIMESTAMP

public TIMESTAMP(String str)

Create a TIMESTAMP object given a Java String object.

Parameters:

str - Java String object

Method Detail

toDate

public static Date toDate(byte[] timestamp)
                   throws SQLException

Convert a byte array representing a TIMESTAMP object to a Java Date Object

Parameters:

timestamp - Oracle TIMESTAMP object

Returns:

the Java date object represented by Oracle TIMESTAMP object

Throws:

SQLException

toTime

public static Time toTime(byte[] timestamp)
                   throws SQLException

Convert a byte array representing a TIMESTAMP object to a Java Time Object

Parameters:

timestamp - Oracle TIMESTAMP object

Returns:

the java.sql.Time object represented by Oracle TIMESTAMP 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

toTimestamp

public static Timestamp toTimestamp(byte[] timestamp)
                             throws SQLException

Convert a byte array representing a TIMESTAMP object to a Java Timestamp Object

Parameters:

timestamp - Oracle TIMESTAMP object

Returns:

the Java timestamp object represented by Oracle TIMESTAMP object

Throws:

SQLException

toTimestamp

public static Timestamp toTimestamp(byte[] timestamp,
                                    Calendar cal)
                             throws SQLException

Convert a byte array representing a TIMESTAMP object to a Java Timestamp Object given Calendar object

Parameters:

timestamp - Oracle TIMESTAMP object to be converted

cal - java.utl.Calendar object

Returns:

the java.sql.Timestamp object represented by the Oracle TIMESTAMP object.

Throws:

SQLException

toDATE

public static DATE toDATE(byte[] timestamp)
                   throws SQLException

Convert a byte array representing a TIMESTAMP object to a Oracle Date Object

Parameters:

timestamp - Oracle TIMESTAMP object

Returns:

the oracle DATE object represented by Oracle TIMESTAMP object

Throws:

SQLException

timestampValue

public Timestamp timestampValue()
                         throws SQLException

Calls toTimestamp to convert internal Oracle Date to a Java Timestamp.

Overrides:

timestampValue in class Datum

Returns:

a Java Timestamp value

Throws:

SQLException

timestampValue

public Timestamp timestampValue(Calendar cal)
                         throws SQLException

Calls toTimestamp to convert internal Oracle Date and Calendar to a Java Timestamp.

Overrides:

timestampValue in class Datum

Returns:

a Java Timestamp value

Throws:

SQLException

toString

public static String toString(byte[] bytes)

Converts a TIMESTAMP to a string

Parameters:

date - a byte array

Returns:

String representing the date

toBytes

public byte[] toBytes()

Convert Oracle Timestamp object into a byte array

Returns:

the byte array stored in the TIMESTAMP object

toBytes

public static byte[] toBytes(Time time)

Convert Java Time to Oracle TIMESTAMP.

Parameters:

time - java.sql.Time object to be converted.

Returns:

the byte array representing the java Time.

toBytes

public static byte[] toBytes(Date date)

Convert Java Date to Oracle TIMESTAMP.

Parameters:

date - java.sql.Date object to be converted.

Returns:

the byte array representing the java Date.

toBytes

public static byte[] toBytes(Timestamp timestamp)

Convert Java Timestamp to Oracle Timestamp

Parameters:

Timestamp - java.sql.Timestamp object to be converted.

Returns:

the byte array representing the java timestamp.

toBytes

public static byte[] toBytes(Timestamp timestamp,
                             Calendar cal)

Convert Java Timestamp and Java Calendar to Oracle Timestamp

Parameters:

Timestamp - java.sql.Timestamp object to be converted.

Calendar - java.util.Calendar object to be converted.

Returns:

the byte array representing the java timestamp.

toBytes

public static byte[] toBytes(DATE date)

Convert Oracle DATE to Oracle Timestamp

Parameters:

date - oracle.sql.Timestamp object to be converted.

Returns:

the byte array representing the oracle DATE.

toBytes

public static byte[] toBytes(String str)

Convert Java String to Oracle TIMESTAMP.

Parameters:

str - java.lang.String object to be converted.

Returns:

the byte array representing the input string.

toJdbc

public Object toJdbc()
              throws SQLException

Returns the JDBC representation of the datum 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

TimeZoneConvert

public static TIMESTAMP TimeZoneConvert(Connection conn,
                                        TIMESTAMP tstamp,
                                        TimeZone tz1,
                                        TimeZone tz2)
                                 throws SQLException

Converts the TIMESTAMP object from one timezone to the other

Parameters:

conn - Java Connection object tstamp TIMESTAMP object to be converted tz1 Source timezone tz2 Destination timezone

Returns:

TIMESTAMP object in the destination timezone

Throws:

SQLException

stringValue

public String stringValue()

Calls toString to convert internal Oracle TIMESTAMP to a Java String.

Overrides:

stringValue in class Datum

Returns:

a Java String value

toString

public String toString()

Overrides:

toString in class Object

getOracleYear

public static int getOracleYear(Calendar cal)

dateValue

public Date dateValue()
               throws SQLException

Calls toDate to convert internal Oracle TIMESTAMP to a Java Date.

Overrides:

dateValue in class Datum

Returns:

a Java Date Object

Throws:

SQLException

timeValue

public Time timeValue()
               throws SQLException

Calls toTime to convert internal Oracle Date to a Java Time.

Overrides:

timeValue in class Datum

Returns:

a Java Time value

Throws:

SQLException

getJavaYear

public static int getJavaYear(int cent,
                              int decade)

Skip navigation links