This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
The moose likes JDBC and the fly likes Comparing Timestamp values? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Comparing Timestamp values?" Watch "Comparing Timestamp values?" New topic

Comparing Timestamp values?

Mike London
Ranch Hand

Joined: Jul 12, 2002
Posts: 1034
How do you compare two Timestamp values to see if one is 'x' minutes older than another, for example?
If you have one Timestamp, say t1 and another, t2, how can you see if the difference in time between them is, say 5 minutes?
Basically, I need to be able to somehow take the difference between to Timestamps to see how much time has elapsed.
From looking at the API, there doesn't seem to be a simple way to do this.
Any help or advice would be appreciated.
-- Mike
Krishna Mohan
Ranch Hand

Joined: May 30, 2003
Posts: 44
See this Link.
Scroll all the way to bottom to see some code.
Hope that helps

Programming is Fun.
Mike London
Ranch Hand

Joined: Jul 12, 2002
Posts: 1034
Hi Krishna,
Yes, this link was very helpful.
-- Mike
I agree. Here's the link:
subject: Comparing Timestamp values?
Similar Threads
In-memory hashmap refresh in servlet
Confused about SQL Timestamp
Timestamp in GMT and the difference
Handling java.sql.Timestamp
Time Stamp values