wood burning stoves*
The moose likes JSP and the fly likes SQL query for deriving DATE Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "SQL query for deriving DATE" Watch "SQL query for deriving DATE" New topic
Author

SQL query for deriving DATE

Manoj Paul
Ranch Hand

Joined: Jan 18, 2007
Posts: 112
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQL query for deriving DATE
 
Similar Threads
Assigning jsonobject to java class having one to many relationship
SQL query for deriving DATE
inserting values in database after calculation
group by week help
Date Confusion