Jdbc java sql timestamp

Jdbc java sql timestamp

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

Field Summary

Fields inherited from class oracle.sql.Datum

Constructor Summary

Method Summary

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

Methods inherited from class oracle.sql.Datum

Methods inherited from class java.lang.Object

Field Detail

SIZE_DATE

public static final int SIZE_DATE

SIZE_TIMESTAMP

public static final int SIZE_TIMESTAMP

SIZE_TIMESTAMP_NOFRAC

public static final int SIZE_TIMESTAMP_NOFRAC

Constructor Detail

TIMESTAMP

TIMESTAMP

public TIMESTAMP​(byte[] timestamp)

TIMESTAMP

TIMESTAMP

TIMESTAMP

TIMESTAMP

TIMESTAMP

TIMESTAMP

Method Detail

toDate

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

toTime

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

toTimestamp

public static Timestamp toTimestamp​(byte[] timestamp) 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

toDATE

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

timestampValue

public Timestamp timestampValue() throws SQLException

timestampValue

public Timestamp timestampValue​(Calendar cal) throws SQLException

toString

toBytes

toBytes

Источник

Class Timestamp

A thin wrapper around java.util.Date that allows the JDBC API to identify this as an SQL TIMESTAMP value. It adds the ability to hold the SQL TIMESTAMP fractional seconds value, by allowing the specification of fractional seconds to a precision of nanoseconds. A Timestamp also provides formatting and parsing operations to support the JDBC escape syntax for timestamp values.

• 19 , which is the number of characters in yyyy-mm-dd hh:mm:ss
• 20 + s , which is the number of characters in the yyyy-mm-dd hh:mm:ss.[fff. ] and s represents the scale of the given Timestamp, its fractional seconds precision.

Note: This type is a composite of a java.util.Date and a separate nanoseconds value. Only integral seconds are stored in the java.util.Date component. The fractional seconds — the nanos — are separate. The Timestamp.equals(Object) method never returns true when passed an object that isn’t an instance of java.sql.Timestamp , because the nanos component of a date is unknown. As a result, the Timestamp.equals(Object) method is not symmetric with respect to the java.util.Date.equals(Object) method. Also, the hashCode method uses the underlying java.util.Date implementation and therefore does not include nanos in its computation.

Due to the differences between the Timestamp class and the java.util.Date class mentioned above, it is recommended that code not view Timestamp values generically as an instance of java.util.Date . The inheritance relationship between Timestamp and java.util.Date really denotes implementation inheritance, and not type inheritance.

Источник

Jdbc java sql timestamp

Note: This type is a composite of a java.util.Date and a separate nanoseconds value. Only integral seconds are stored in the java.util.Date component. The fractional seconds — the nanos — are separate. The Timestamp.equals(Object) method never returns true when passed an object that isn’t an instance of java.sql.Timestamp , because the nanos component of a date is unknown. As a result, the Timestamp.equals(Object) method is not symmetric with respect to the java.util.Date.equals(Object) method. Also, the hashCode method uses the underlying java.util.Date implementation and therefore does not include nanos in its computation.

Due to the differences between the Timestamp class and the java.util.Date class mentioned above, it is recommended that code not view Timestamp values generically as an instance of java.util.Date . The inheritance relationship between Timestamp and java.util.Date really denotes implementation inheritance, and not type inheritance.

Constructor Summary

Method Summary

Returns the number of milliseconds since January 1, 1970, 00:00:00 GMT represented by this Timestamp object.

Sets this Timestamp object to represent a point in time that is time milliseconds after January 1, 1970 00:00:00 GMT.

Obtains an instance of Timestamp from a LocalDateTime object, with the same year, month, day of month, hours, minutes, seconds and nanos date-time value as the provided LocalDateTime .

Methods declared in class java.util.Date

Methods declared in class java.lang.Object

Constructor Detail

Timestamp

@Deprecated(since="1.2") public Timestamp​(int year, int month, int date, int hour, int minute, int second, int nano)

Timestamp

public Timestamp​(long time)

Constructs a Timestamp object using a milliseconds time value. The integral seconds are stored in the underlying date value; the fractional seconds are stored in the nanos field of the Timestamp object.

Method Detail

setTime

public void setTime​(long time)

Sets this Timestamp object to represent a point in time that is time milliseconds after January 1, 1970 00:00:00 GMT.

getTime

Returns the number of milliseconds since January 1, 1970, 00:00:00 GMT represented by this Timestamp object.

valueOf

toString

Formats a timestamp in JDBC timestamp escape format. yyyy-mm-dd hh:mm:ss.fffffffff , where fffffffff indicates nanoseconds.

getNanos

setNanos

public void setNanos​(int n)

Источник

Class Timestamp

A thin wrapper around java.util.Date that allows the JDBC API to identify this as an SQL TIMESTAMP value. It adds the ability to hold the SQL TIMESTAMP fractional seconds value, by allowing the specification of fractional seconds to a precision of nanoseconds. A Timestamp also provides formatting and parsing operations to support the JDBC escape syntax for timestamp values.

• 19 , which is the number of characters in yyyy-mm-dd hh:mm:ss
• 20 + s , which is the number of characters in the yyyy-mm-dd hh:mm:ss.[fff. ] and s represents the scale of the given Timestamp, its fractional seconds precision.

Note: This type is a composite of a java.util.Date and a separate nanoseconds value. Only integral seconds are stored in the java.util.Date component. The fractional seconds — the nanos — are separate. The Timestamp.equals(Object) method never returns true when passed an object that isn’t an instance of java.sql.Timestamp , because the nanos component of a date is unknown. As a result, the Timestamp.equals(Object) method is not symmetric with respect to the java.util.Date.equals(Object) method. Also, the hashCode method uses the underlying java.util.Date implementation and therefore does not include nanos in its computation.

Due to the differences between the Timestamp class and the java.util.Date class mentioned above, it is recommended that code not view Timestamp values generically as an instance of java.util.Date . The inheritance relationship between Timestamp and java.util.Date really denotes implementation inheritance, and not type inheritance.

Источник

Jdbc java sql timestamp

Returns the number of milliseconds since January 1, 1970, 00:00:00 GMT represented by this Timestamp object.

Sets this Timestamp object to represent a point in time that is time milliseconds after January 1, 1970 00:00:00 GMT.

Obtains an instance of Timestamp from a LocalDateTime object, with the same year, month, day of month, hours, minutes, seconds and nanos date-time value as the provided LocalDateTime .

Methods inherited from class java.util.Date

Methods inherited from class java.lang.Object

Constructor Detail

Timestamp

@Deprecated public Timestamp(int year, int month, int date, int hour, int minute, int second, int nano)

Timestamp

public Timestamp(long time)

Constructs a Timestamp object using a milliseconds time value. The integral seconds are stored in the underlying date value; the fractional seconds are stored in the nanos field of the Timestamp object.

Method Detail

setTime

public void setTime(long time)

Sets this Timestamp object to represent a point in time that is time milliseconds after January 1, 1970 00:00:00 GMT.

getTime

Returns the number of milliseconds since January 1, 1970, 00:00:00 GMT represented by this Timestamp object.

valueOf

toString

Formats a timestamp in JDBC timestamp escape format. yyyy-mm-dd hh:mm:ss.fffffffff , where ffffffffff indicates nanoseconds.

getNanos

setNanos

public void setNanos(int n)

equals

equals

Tests to see if this Timestamp object is equal to the given object. This version of the method equals has been added to fix the incorrect signature of Timestamp.equals(Timestamp) and to preserve backward compatibility with existing class files. Note: This method is not symmetric with respect to the equals(Object) method in the base class.

before

after

compareTo

compareTo

hashCode

Returns a hash code value for this object. The result is the exclusive OR of the two halves of the primitive long value returned by the Date.getTime() method. That is, the hash code is the value of the expression:

 (int)(this.getTime()^(this.getTime() >>> 32)) 

The hashCode method uses the underlying java.util.Date implementation and therefore does not include nanos in its computation.

valueOf

public static Timestamp valueOf(LocalDateTime dateTime)

Obtains an instance of Timestamp from a LocalDateTime object, with the same year, month, day of month, hours, minutes, seconds and nanos date-time value as the provided LocalDateTime . The provided LocalDateTime is interpreted as the local date-time in the local time zone.

toLocalDateTime

Converts this Timestamp object to a LocalDateTime . The conversion creates a LocalDateTime that represents the same year, month, day of month, hours, minutes, seconds and nanos date-time value as this Timestamp in the local time zone.

from

Obtains an instance of Timestamp from an Instant object. Instant can store points on the time-line further in the future and further in the past than Date . In this scenario, this method will throw an exception.

toInstant

Converts this Timestamp object to an Instant . The conversion creates an Instant that represents the same point on the time-line as this Timestamp .

Submit a bug or feature
For further API reference and developer documentation, see Java SE Documentation. That documentation contains more detailed, developer-targeted descriptions, with conceptual overviews, definitions of terms, workarounds, and working code examples.
Copyright © 1993, 2023, Oracle and/or its affiliates. All rights reserved. Use is subject to license terms. Also see the documentation redistribution policy.

Источник