SQLTimestamp is stored in 3 ints - an encoded date, an encoded time and nanoseconds encodedDate = 0 indicates a null WSCTimestamp SQLTimestamp is similar to SQLTimestamp, but it does conserves space by not keeping a GregorianCalendar object PERFORMANCE OPTIMIZATION: We only instantiate the value field when required due to the overhead of the Date methods. Thus, use isNull() instead of "value == null" and getTimestamp() instead of using value directly.
| Modifier and Type | Field and Description |
|---|---|
| private static final int | |
| pack-priv static final char | |
| private static final char[] | |
| private static final char[] | |
| private static final char[] | |
| private int | |
| private int | |
| private static final char[] | |
| pack-priv static final int | |
| private static final char | |
| private static final char | |
| pack-priv static final int | |
| private int | |
| private static final char | |
| private static final char | |
| pack-priv static final int | |
| private static final char[] | |
| private static final char[] |
| Access | Constructor and Description |
|---|---|
| public | |
| public | SQLTimestamp(Timestamp
the Timestamp value to be represented by this instance value, Calendar the time zone of the calendar is used to construct the
database timestamp value cal)Create a new SQLTimestamp instance that represents the specified Timestamp in the time zone of the given Calendar. |
| public | SQLTimestamp(Timestamp
the Timestamp value to be represented by this instance value)Create a new SQLTimestamp instance that represents the specified Timestamp in the local time zone. |
| pack-priv | |
| public | |
| public | SQLTimestamp(String timestampStr, boolean isJDBCEscape, LocaleFinder localeFinder)
Construct a timestamp from a string. |
| public | SQLTimestamp(String timestampStr, boolean isJDBCEscape, LocaleFinder localeFinder, Calendar cal)
Construct a timestamp from a string. |
| Modifier and Type | Method and Description |
|---|---|
| private void | |
| public DataValueDescriptor | cloneValue(boolean
any streams representing the data value will
be materialized if forceMaterialization)true, the data value will be kept as a
stream if possible if falseImplements org. Clone this DataValueDescriptor. |
| public int | compare(DataValueDescriptor
The Orderable to compare this one to. other)Implements org. Compare this Orderable with a given Orderable for the purpose of index positioning. |
| public boolean | compare(int
Orderable.ORDER_OP_EQUALS means do an = comparison.
Orderable.ORDER_OP_LESSTHAN means compare this < other.
Orderable.ORDER_OP_LESSOREQUALS means compare this <= other. op, DataValueDescriptor The DataValueDescriptor to compare this one to. other, boolean True means to treat nulls as ordered values,
that is, treat SQL null as equal to null, and less
than all other values.
False means to treat nulls as unknown values,
that is, the result of any comparison with a null
is the UNKNOWN truth value. orderedNulls, boolean The return value to use if the result of the
comparison is the UNKNOWN truth value. In other
words, if orderedNulls is false, and a null is
involved in the comparison, return unknownRV.
This parameter is not used orderedNulls is true. unknownRV)Overrides org. Implements org. Compare this Orderable with a given Orderable for the purpose of qualification and sorting. |
| private static int | Returns: the encodedDatethe value to convert value, Calendar currentCal)computeEncodedDate sets the date in a Calendar object and then uses the SQLDate function to compute an encoded date The encoded date is year << 16 + month << 8 + date |
| private static int | Returns: the encodedTimethe value to convert value, Calendar currentCal)computeEncodedTime extracts the hour, minute and seconds from a java.util.Date value and encodes them as hour << 16 + minute << 8 + second using the SQLTime function for encoding the data |
| public static DateTimeDataValue | computeTimestampFunction(DataValueDescriptor operand, DataValueFactory dvf)
Compute the SQL timestamp function. |
| public int | estimateMemoryUsage()
Implements org. Estimate the memory usage in bytes of the data value and the overhead of the class. |
| public Date | getDate(Calendar
calendar for object creation cal)Overrides org. Implements org. getDate returns the date portion of the timestamp Time is set to 00:00:00.0 Since Date is a JDBC object we use the JDBC definition for the time portion. |
| public NumberDataValue | getDate(NumberDataValue
The result of the previous call to this method, null
if not called yet. result)Implements org. Get the day of the month. |
| public NumberDataValue | getHours(NumberDataValue
The result of the previous call to this method, null
if not called yet. result)Implements org. Get the hour of the day out of a time or timestamp. |
| public int | getLength()
Implements org. Gets the length of the data value. |
| public NumberDataValue | getMinutes(NumberDataValue
The result of the previous call to this method, null
if not called yet. result)Implements org. Get the minute of the hour out of a time or timestamp. |
| public NumberDataValue | getMonth(NumberDataValue
The result of the previous call to this method, null
if not called yet. result)Implements org. Get the month number out of a date. |
| public DataValueDescriptor | getNewNull()
Implements org. Get a new null value of the same type as this data value. |
| public Object | getObject()
Overrides org. Implements org. Gets the value in the data value descriptor as a Java Object. |
| public NumberDataValue | getSeconds(NumberDataValue
The result of the previous call to this method, null
if not called yet. source)Implements org. Get the second of the minute out of a time or timestamp. |
| public String | getString()
Implements org. Gets the value in the data value descriptor as a String. |
| public Time | getTime(Calendar
calendar for object creation cal)Overrides org. Implements org. getTime returns the time portion of the timestamp Date is set to 1970-01-01 Since Time is a JDBC object we use the JDBC definition for the date portion. |
| public Timestamp | Returns: The value field.calendar for object creation cal)Overrides org. Implements org. Get the value field. |
| public int | getTypeFormatId()
Implements org. Return my format identifier. |
| public String | getTypeName()
Implements org. Get the SQL name of the datatype |
| public NumberDataValue | getYear(NumberDataValue
The result of the previous call to this method, null
if not called yet. result)Implements org. Get the year number out of a date. |
| public int | |
| public final boolean | Returns: Whether or not value is logically null.Implements org. Check if the value is null. |
| pack-priv NumberDataValue | |
| pack-priv NumberDataValue | |
| pack-priv static int[] | Returns: {encodedDate, encodedTime, nanosecond} array.a DateTimeParser initialized with a string. parser, boolean If true then an error will be thrown if the time is missing. If false then the time may
be omitted. timeRequired)Parse a timestamp or a date. |
| pack-priv static int | |
| pack-priv static int[] | Returns: a {encodedDate, encodedTime} array.the timestamp string, with trailing blanks removed. str, LocaleFinder localeFinder, Calendar cal)Parse a localized timestamp. |
| private void | |
| pack-priv static SQLTimestamp | Returns: the corresponding timestamp, using the current date if datetime is a time, or time 00:00:00 if datetime is a date.Promotes a DateTimeDataValue to a timestamp. |
| public void | readExternal(ObjectInput
the stream to read data from in order to restore the object in)Implements java. The object implements the readExternal method to restore its contents by calling the methods of DataInput for primitive types and readObject for objects, strings and arrays. |
| public void | restoreToNull()
Implements org. Restore this object to its (SQL)null value. |
| private void | |
| protected void | setFrom(DataValueDescriptor
The DataValueDescriptor that holds the value to
which we want to set this DataValueDescriptor's value. theValue)Overrides org. Set the value of this DataValueDescriptor based on the value of the specified DataValueDescriptor. |
| public void | setInto(PreparedStatement ps, int position)
Overrides org. Implements org. Set this value into a PreparedStatement. |
| private void | |
| pack-priv void | setObject(Object theValue)
Overrides org. Set the value from a correctly typed Timestamp object. |
| public void | setValue(Date
The Date value to set this DataValueDescriptor to value, Calendar The time zone from the calendar is used to construct the database date value cal)Overrides org. Implements org. Set the value of this DataValueDescriptor. |
| public void | setValue(Timestamp
The Timestamp value to set this DataValueDescriptor to value, Calendar The time zone from the calendar is used to construct the database timestamp value cal)Overrides org. Implements org. Set the value of this DataValueDescriptor. |
| public void | setValue(String
The String value to set this DataValueDescriptor to theValue)Overrides org. Implements org. Set the value of this DataValueDescriptor. |
| public void | setValueFromResultSet(ResultSet
The specified ResultSet. resultSet, int The 1-based column # into the resultSet. colNumber, boolean Whether or not the column is nullable
(No need to call wasNull() if not) isNullable)Implements org. Set the value based on the value for the specified DataValueDescriptor from the specified ResultSet. |
| public DateTimeDataValue | Returns: startTime + intervalCount intervals, as a timestampOne of FRAC_SECOND_INTERVAL, SECOND_INTERVAL, MINUTE_INTERVAL, HOUR_INTERVAL,
DAY_INTERVAL, WEEK_INTERVAL, MONTH_INTERVAL, QUARTER_INTERVAL, or YEAR_INTERVAL intervalType, NumberDataValue The number of intervals to add count, Date Used to convert time to timestamp currentDate, DateTimeDataValue If non-null a DateTimeDataValue that can be used to hold the result. If null then
generate a new holder resultHolder)Implements org. Add a number of intervals to a datetime value. |
| public NumberDataValue | Returns: the number of intervals by which this datetime is greater than time1One of FRAC_SECOND_INTERVAL, SECOND_INTERVAL, MINUTE_INTERVAL, HOUR_INTERVAL,
DAY_INTERVAL, WEEK_INTERVAL, MONTH_INTERVAL, QUARTER_INTERVAL, or YEAR_INTERVAL intervalType, DateTimeDataValue time1, Date Used to convert time to timestamp currentDate, NumberDataValue If non-null a NumberDataValue that can be used to hold the result. If null then
generate a new holder resultHolder)Implements org. Finds the difference between two datetime values as a number of intervals. |
| public String | |
| public int | typePrecedence()
Overrides org. Implements org. Each built-in type in JSQL has a precedence. |
| public void | writeExternal(ObjectOutput
the stream to write the object to out)Implements java. The object implements the writeExternal method to save its contents by calling the methods of DataOutput for its primitive values or calling the writeObject method of ObjectOutput for objects, strings, and arrays. |