Class java.sql.Timestamp
All Packages  Class Hierarchy  This Package  Previous  Next  Index

Class java.sql.Timestamp

Object
   |
   +----Date
           |
           +----java.sql.Timestamp

public class Timestamp
extends Date

This class is a thin wrapper around java.util.Date that allows JDBC to identify this as a SQL TIMESTAMP value. It adds the ability to hold the SQL TIMESTAMP nanos value and provides formatting and parsing operations to support the JDBC escape syntax for timestamp values.

Note: This type is a composite of a java.util.Date and a separate nanos value. Only integral seconds are stored in the java.util.Date component. The fractional seconds - the nanos - are separate. The getTime method will only return integral seconds. If a time value that includes the fractional seconds is desired you must convert nanos to milliseconds (nanos/1000000) and add this to the getTime value. Also note that the hashcode() method uses the underlying java.util.Data implementation and therefore does not include nanos in its computation.


Constructor Index

 o java.sql.Timestamp(int, int, int, int, int, int, int)
Construct a Timestamp Object
 o java.sql.Timestamp(long)
Construct a Timestamp using a milliseconds time value.

Method Index

 o after(Timestamp)
Is this timestamp later than the timestamp argument?
 o before(Timestamp)
Is this timestamp earlier than the timestamp argument?
 o equals(Timestamp)
Test Timestamp values for equality
 o getNanos()
Get the Timestamp's nanos value
 o setNanos(int)
Set the Timestamp's nanos value
 o toString()
Format a timestamp in JDBC timestamp escape format
 o valueOf(String)
Convert a string in JDBC timestamp escape format to a Timestamp value

Constructors

 o Timestamp
public Timestamp(int year,
                 int month,
                 int date,
                 int hour,
                 int minute,
                 int second,
                 int nano)
Construct a Timestamp Object

Parameters:
year - year-1900
month - 0 to 11
day - 1 to 31
hour - 0 to 23
minute - 0 to 59
second - 0 to 59
nano - 0 to 999,999,999
 o Timestamp
public Timestamp(long time)
Construct a Timestamp using a milliseconds time value. The integral seconds are stored in the underlying date value; the fractional seconds are stored in the nanos value.

Parameters:
time - milliseconds since January 1, 1970, 00:00:00 GMT

Methods

 o after
public boolean after(Timestamp ts)
Is this timestamp later than the timestamp argument?

Parameters:
ts - the Timestamp value to compare with
 o before
public boolean before(Timestamp ts)
Is this timestamp earlier than the timestamp argument?

Parameters:
ts - the Timestamp value to compare with
 o equals
public boolean equals(Timestamp ts)
Test Timestamp values for equality

Parameters:
ts - the Timestamp value to compare with
 o getNanos
public int getNanos()
Get the Timestamp's nanos value

Returns:
the Timestamp's fractional seconds component
 o setNanos
public void setNanos(int n)
Set the Timestamp's nanos value

Parameters:
n - the new fractional seconds component
 o toString
public java.lang.String toString()
Format a timestamp in JDBC timestamp escape format

Returns:
a String in yyyy-mm-dd hh:mm:ss.fffffffff format
Overrides:
toString in class Date
 o valueOf
public static java.sql.Timestamp valueOf(String s)
Convert a string in JDBC timestamp escape format to a Timestamp value

Parameters:
s - timestamp in format "yyyy-mm-dd hh:mm:ss.fffffffff"
Returns:
corresponding Timestamp

All Packages  Class Hierarchy  This Package  Previous  Next  Index