Date is there. Timestamp is not.

[Chris Montgomery]

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:
...

ResultSet rs = gimmeStuff();
if(rs has stuff)
{
Calendar cal = Calendar.getInstance();
cal.setTime(  rs.getDate( "my_mysql_datetime") );
domainObj.setDBCalTime( cal );
}

...


Thanks!!

Chris

[Rob Spoor]

Use rs.getTimestamp(). rs.getDate() removes time information, rs.getTime() removes date information, rs.getTimestamp preserves both.