take the total time for particular period

[baktha.thalapathy]

i am getting the timestamp from database

2010-06-01 09:36:13
2010-06-01 09:37:14
2010-06-01 09:38:14
2010-06-01 09:39:14
2010-06-01 09:39:45
2010-06-01 17:05:27
2010-06-01 17:06:28
2010-06-01 17:07:28
2010-06-01 17:08:28
2010-06-01 17:10:29
2010-06-01 17:11:29
2010-06-01 17:12:29
2010-06-01 17:13:29

i need output
Code:

from                              to
2010-06-01 09:36:13      2010-06-01 09:39:45-->take the total time(output)
2010-06-01 17:05:27     2010-06-01 17:08:28-->take the total time(output)
2010-06-01 17:10:29     2010-06-01 17:13:29-->take the total time(output)

example
like this
2010-06-01 17:05:27-start time
2010-06-01 17:08:28-end time(total time)
2010-06-01 17:10:29-start time
2010-06-01 17:13:29-end time(total time)


please help me how to write the java code to get the above output

[j2me64]

i am getting the timestamp from database

2010-06-01 09:36:13
2010-06-01 09:37:14
2010-06-01 09:38:14
2010-06-01 09:39:14
2010-06-01 09:39:45
2010-06-01 17:05:27
2010-06-01 17:06:28
2010-06-01 17:07:28
2010-06-01 17:08:28
2010-06-01 17:10:29
2010-06-01 17:11:29
2010-06-01 17:12:29
2010-06-01 17:13:29

i need output
Code:

from                              to
2010-06-01 09:36:13      2010-06-01 09:39:45-->take the total time(output)
2010-06-01 17:05:27     2010-06-01 17:08:28-->take the total time(output)
2010-06-01 17:10:29     2010-06-01 17:13:29-->take the total time(output)

example
like this
2010-06-01 17:05:27-start time
2010-06-01 17:08:28-end time(total time)
2010-06-01 17:10:29-start time
2010-06-01 17:13:29-end time(total time)


please help me how to write the java code to get the above output

sure, but can you post your code you have so far? to get the output you want is quite easy by we have to now how your resultset looks.

[JosAH]

For two timestamps TS1 < TS2 the time difference is TS2-TS1 measured in milli seconds. btw. why did you start a new thread for this?

kind regards,

Jos

[Tolls]

Isn't this the third thread you've started on the same topic?