• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Date is there. Timestamp is not.

 
Chris Montgomery
Ranch Hand
Posts: 141
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I need to do get the difference in MINUTES between now (Calendar.getInstance()) and a datetime value from MySQL.

Java is telling me Calendar.getInstance() is:
Fri Jul 24 19:15:03 CDT 2009

In my table, the value stored is:
2009-07-24 18:59:45

After retrieving the data from my database, Java stored the datetime value as this:
Fri Jul 24 00:00:00 CDT 2009

As a result, I can't get the correct difference in minutes.

Here's how I'm loading up my domain object:
...

...


Thanks!!

Chris

 
Rob Spoor
Sheriff
Pie
Posts: 20545
56
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Use rs.getTimestamp(). rs.getDate() removes time information, rs.getTime() removes date information, rs.getTimestamp preserves both.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic