casting date

[Paula Vasseur]

I want to enter day, month and year in separate drop down boxes on an Html form, but store these in a DATE column in my database as 12/06/03, how do i convert this, I am using JSPs.
Thanks Paula

[Ernest Friedman-Hill]

You want to do something like

import java.util.Calendar;
import java.sql.Date;
...
int year = ...
int month = ...
int day = ...
Calendar c = new Calendar();
c.set(year, month, day);
Date d = new Date(c.getTimeMillis());

Then you can use the Date object d in a setDate() call on a PreparedStatement, for instance.

[Paula Vasseur]

Thanks very much, got it working, you are a life saver.
Slainte Paula