adding to java.sql.Date

[Patrick Mallahan]

How would I go about incrementing days with java.sql.Date? I need to increse an sql.Date by 7 but I dont know how to add to an sql.Date. Can someone help me please?

[Christopher Elkins]

Create a java.util.GregorianCalendar and use it to perform the arithmetic.

[Patrick Mallahan]

i hoping nobody would say that but oh well, I guess that is the only way. Is that the case?

[Christopher Elkins]

I'm not sure that I understand your aversion to Calendar objects, but yes, that's the only way I can think of to do it. Sorry.

[Patrick Mallahan]

so i understand how to add to a greg cal but how to i convert it back to a sql.Date?

[Padma Lalwani]

Try new Date(gregorianCalendar.getTimeInMillis())

Padma

[Raymond Villeno]

I think this would work too...

  
 
Calendar cNow = Calendar.getInstance();
        Date dNow = cNow.getTime();
        cNow.add(Calendar.DATE, 7);
 
        Date dSeven = cNow.getTime();
 
        SimpleDateFormat format = new SimpleDateFormat("MMM dd, yyyy hh:mm:ss a");
       
        String dateNow = format.format(dNow);
        String dayBefore = format.format(dSeven);
        System.out.println(dateNow);
        System.out.println(daySeven); //here is your current day + 7
 
        Date date = new Date();
        System.out.println(date);
 

Cheers!