CODEWITHSUNDEEP
javaspringtime
Vlad Schnakovszki
Vlad Schnakovszki

Reputation: 8601

Adding minutes to Time object in Java

I am using Java to interact with a MySQL database that contains Time type values. I can read this directly into Java Time objects by using the getTime() method from the ResultSet class.

How can I add a number of minutes to the current Time object?

I am not allowed to use Joda Time or other external libraries nor change the database types.

I have read everything I could find (this, this and many others) but none of the responses actually use Time objects.

Upvotes: 0

Views: 2924

Answers (3)

Marko Topolnik
Marko Topolnik

Reputation: 200196

Time extends Date so you can use the techniques involving the Date and Calendar APIs.

import static java.util.Calendar.MINUTE;

...

final Time t = ... your Time instance ...;
final Calendar c = Calendar.getInstance();
c.setTime(t);
c.add(MINUTE, 10);
t.setTime(c.getTimeInMillis());

...keeping your fingers crossed that this didn't mess up something with the time zones/daylight saving time transitions.

Upvotes: 4

Octoshape
Octoshape

Reputation: 1141

Since SQL Time object only store milliseconds now (everything else is deprecated) you can simply convert it to a Calendar object and add minutes to that like so:

Time mySqlTimeObject = getTime();

Calendar cal = Calendar.getInstance();
cal.setTimeInMillis(mySqlTimeObject.getTime());
cal.set(Calendar.MINUTE, cal.get(Calendar.MINUTE) + 10);

Time myNewSqlTimeObject = new Time(cal.get(Calendar.MILLISECOND));

Upvotes: 3

djvazquez
djvazquez

Reputation: 170

I think you can convert Time to java.util.Date, for example:

        Time time = new Time (12,1,1);
        Date date = new Date(time.getTime());

        Calendar cal = Calendar.getInstance();
        cal.setTime(date);
        cal.add(Calendar.MINUTE, 10);


        time = new Time (cal.getTime().getTime());

Upvotes: 2

Related Questions