i can't save my date into my oracle...

i have this:

String date1 = "01/01/2006";//mm/dd/yyyy

insertSql1 = "INSERT INTO TABLE_NAME VALUES(TO_DATE(?,'mm/dd/yyyy'))";

//System.out.println("insertSql: "+insertSql1);

pstmt = con.prepareStatement(insertSql1);

pstmt.setString(1,date1);pstmt.executeUpdate();

con.commit();

pstmt.close();

con.close();

jgalacambraa at 2007-7-13 19:08:24 >