DATE

[Rocko Smith]

I'm trying to assign a date to a column in a oracle table. The format of the date I'm trying to pass is 06/01/2005. I have looked at the api for DATE, but can't figure out how to get the date of 06/01/2005 into the field on the table, which is defined as DATE.
Could somebody help me with this problem?

Here's what I have so far:

sql = "insert into table1(acct_id,date1,date2) values(?,?,?)"

String a = null;
String d1 = "06/01/2005";
String d2 = "06/01/2006";

stmt.setString(1,a);
stmt.setDate(2,d1);
stmt.setDate(3,d2);

[Bear Bibeault]

Please do not cross-post the same question in multiple forums. It wastes people's time when multiple redundant conversations take place.