Calculating date in mysql with java

Question

I'm having trouble, finding out how to calculate or get the date from mysql (using java program) after 1 month of the initial saved date given below:

Date rDate = new Date();
java.sql.Date regDate = new java.sql.Date(rDate.getTime());

I am saving the date into a date column in mysql and I want to have another column which contains the date but one month ahead. In other words I have a registration date and I want to have an expiration date calculated automatically which allows only 1 month. Is it possible?

score 3 · Accepted Answer · answered Aug 02 '16 at 21:19

3

Grabbing the current date and set it into the Calendar format and add 1 to the month.

You can give this a try.

Date rDate = new Date();
Calendar cal = Calendar.getInstance();
cal.setTime(rDate);
cal.add(Calendar.MONTH, 1);

answered Aug 02 '16 at 21:19

Alvin

408
3
14

Thanks a lot @Alvin. Had no idea it was that easy. – Randy Aug 02 '16 at 21:29
No problem! Accept this as correct answer if it's working by clicking the tick. – Alvin Aug 02 '16 at 21:30
There's many answers posted for such qns, here's one [example](http://stackoverflow.com/questions/2592501/how-to-compare-dates-in-java) – Alvin Aug 02 '16 at 21:37
Yeah, I later realized and deleted my comment but thank you – Randy Aug 02 '16 at 21:39
No problem, always glad to help! – Alvin Aug 02 '16 at 21:40

score 3 · Answer 2 · answered Aug 02 '16 at 21:22

3

You can use Calendar class to manipulate date fields:

Calendar cal = Calendar.getInstance();
cal.add(Calendar.MONTH, 1);
Date futureDate = cal.getTime();

answered Aug 02 '16 at 21:22

ujulu

3,289
2
11
14

Thank you @ujulu. I had searched a lot for the answer. Guessed I should have just read up on the Calendar class. – Randy Aug 02 '16 at 21:30

Calculating date in mysql with java

2 Answers2