Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL query for deriving DATE

 
Manoj Paul
Ranch Hand
Posts: 112
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In my Jsp program, i have 3 schemes, one for 1 month, second for 3 month, and third for 12 month.
Now an user can create his account and select any of the 3 schemes, what i want is that in my database table there are two columns one is tha startdate colume which holds data for the date posted, ie, current date, and the other column is the enddate which holds data for the expiry date depending on the schemes selected....
What i want is that when a user register for an account his startdate is the present date and i want a query which automatically calculates the enddate keeping in mind the scheme and update the table with the derived result.
Thanks
 
Arulanand Dayalan
Ranch Hand
Posts: 128
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can try some thing like this if it is DB2

Insert into SCEMETABLE (CRT_DT , EXP_DT) values ( current date , current date + 15 MONTHS )

You Can build the Query dynamically to pass the months depending on the scheme and execute it.

Hope this helps.

Thanks and Regards,
Arul.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic