Adding dates how can i do that

[kirtichopra2003]

Hi all
I want to add dates i am storing date in the format yyyy-mm-dd in my db and want to add 0.6 months or 1.0 years to it how can i do that

[Eranga]

Is this related to Java or you are looking on DB point of view?

[kirtichopra2003]

Hi all
I want to add month in date and store this value to database i have tried this

accountSubscription.setEnddate(cal.add(Calendar.MO NTH,month);)

i can not use the following method as it cannot set as Date in db how can i do this pls help
cal.add(Calendar.MONTH,month);


Thanks Kirti

[r035198x]

Read the API specs for those methods. The add method returns void, nothing. So you can't pass it's (nonexistent) return value to a method that expects something.
Better do something like

cal.add(Calendar.MONTH, month);
accountSubscription.setEnddate(cal.getTime());

[kirtichopra2003]

But won't this will give time also i only want the date and that to in yyyy-mm-dd format

[masijade]

Dates don't have a format. If the field set by setEnddate is a a "Date", then this does what you want. How you display that Date is a different discussion.

[r035198x]

But won't this will give time also i only want the date and that to in yyyy-mm-dd format

You shouldn't worry about formats when storing dates into the database.
All you do is setTimestamp() and all is done for you. You only worry about formats when presenting the data to users.

[kirtichopra2003]

Ok
thank you so much its working fine