How do you calculate elapsed number of days

[Anjum]

X-No-Archive: Yes

I retrieve date from mySQL using ResultSet.getDate("<field name>")
metbod. How do I calculate how many days have elapsed between that date
and today's date.

For example,

ResultSet rs = ...
rs.getDate("<field name");

Please note that I strictly use JSP and not Java classes.

Thanks,

 

[=?ISO-8859-1?Q?Arne_Vajh=F8j?=]

I retrieve date from mySQL using ResultSet.getDate("<field name>")
metbod. How do I calculate how many days have elapsed between that date
and today's date.

Something like:

(rs.getDate("fieldname").getTime() - (new Date()).getTime())/(24 * 60 *
60 * 1000L)

I would assume.

Arne

 

[Anjum]

X-No-Archive: Yes

Something like:

(rs.getDate("fieldname").getTime() - (new Date()).getTime())/(24 * 60 *
60 * 1000L)

I would assume.

Thanks, it did not work due to a conflict between the Date object
obtained from RS and the Date() object. However, the error message I
received and your own technique above gave me enough clues to
experiment and the following worked:

long theTime = System.currentTimeMillis();
java.sql.Date theDate = new Date(theTime);

long noOfDaysElapsed = 0;
noOfDaysElapsed = (theDate.getTime() - rs.getDate("<field
name>").getTime())/(24 * 60 * 60 * 1000L);

Thanks for your assistance.

 

[Lew]

java.sql.Date theDate = new Date(theTime);

That this compiled indicates that you have imported "java.sql.Date" and not
"java.util.Date". In that case you are not absolutely required to specify the
package name in the type declaration of "theDate", although of course it does
no harm whatsoever. OTOH, one could argue that by showing the package you are
enhancing the self-documentation of the code by emphasizing that this is the
"sql" version of Date. I believe I will adopt this idiom where it enhances
understanding in that fashion.

- Lew