Time Difference

[R Sugan]

Hi,

I need to check the difference between the time in database and system time.I am having both the times in yy:mm:dd hh:mm:ss format.please reply me how to do this .very urgent.I am getting both the time in string like

String calledtime=rs.getString("calledtime");
SimpleDateFormat formatter = new SimpleDateFormat ("yyyy-MM-dd HH:mm:ss") ;
String currenttime = formatter.format (new Date()) ;




I am getting the output printed as
2008-05-02 16:52:17
2008-05-20 15:10:44


I need this output like this 00:00:00

00:00:01
00:00:02
00:00:03
00:00:04
00:00:05


Thanks.

[Aurelian Tutuianu]

You have to obtain the to dates in Date instances. From there you get two milliseconds using Date.getTime. After that obtain the difference in milliseconds and with the difference create a new Date. Using SimpleDateFormat you cand print the difference.

So, as a rule of thumb, obtain milliseconds and do calculations in milliseconds. Don't parse or use Strings, is too complicated.

An example:

    private void dateDiff( Date date1, Date date2 ) {
        long m1 = date1.getTime();
        long m2 = date2.getTime();

        Date diff = new Date( m2 - m1 );

        SimpleDateFormat sdf = new SimpleDateFormat("HH:mm:ss");
        sdf.setTimeZone( TimeZone.getTimeZone( "GMT" ));
        System.out.println ( sdf.format( diff ) );
    }

Notice the usage of TimeZone, that is important.

[Campbell Ritchie]

Closing as duplicate of this post. Please read this FAQ.