date function

Thread view:

Irlan agous - 05 Apr 2005 20:52 GMT

Hello all,
I dont know how to get mysels a date in java.
when i have a date i want to run an sql query to select the payment

also i want to check that after
6 montths the value of payment will be 0 again. So it has to check the date
after 6 months

Irlan

Reply to this Message

Wannabee - 06 Apr 2005 07:00 GMT

> Hello all,
> I dont know how to get mysels a date in java.
[quoted text clipped - 3 lines]
> 6 montths the value of payment will be 0 again. So it has to check the date
> after 6 months

Maybe this helps? (untested)

java.sql.Date sqldate = new java.sql.Date();
// sqldate.toString() gives a String which can be used in a SQL-statement
// like ... " WHERE DTE = '" + sqldate.toString() + "' AND " ...
// if the type of the field DTE is DATE

java.util.Calendar cal = new java.util.GregorianCalendar();
cal.setTime(sqldate);
cal.add(java.util.Calendar.MONTH, 6); // add 6 months
sqldate = cal.getTime();

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...