date problem

[Bill Walker]

I have a string containing date of birth in mmddccyy format. How do I change it to a Date variable so I can insert it into a Date/Time database field?

[John Gooch]

Here is some code that works with Oracle 8.1.7
where sSolDate = "2002-02-05"
java.sql.Date d = java.sql.Date.valueOf(sSolDate);
String sInsSol = "INSERT INTO ASFI_SOLICITATION " + "(SOLICITATION_NBR, AMMEND_NBR, RFQ_STATUS,
CONTRACT_OFC_ID, SOLICITATION_DATE) " +
" VALUES (?, ?, ?, ?, ? )";
try
{ PreparedStatement pInsertSol = cSolCon.prepareStatement(sInsSol);
pInsertSol.setString(1, sSolNum);
pInsertSol.setString(2, sAmendNum);
pInsertSol.setString(3, sSolType );
pInsertSol.setString(4, sContractOfc );
pInsertSol.setDate(5, d );
pInsertSol.executeUpdate();
}
catch (SQLException e)
{ System.err.println("Unable to create ASFI_SOLICITATION " + e);
System.exit(1);
}

[John Gooch]

Here is some code that works with Oracle 8.1.7
where sSolDate = "2002-02-05"
java.sql.Date d = java.sql.Date.valueOf(sSolDate);
String sInsSol = "INSERT INTO ASFI_SOLICITATION " + "(SOLICITATION_NBR, AMMEND_NBR, RFQ_STATUS,
CONTRACT_OFC_ID, SOLICITATION_DATE) " +
" VALUES (?, ?, ?, ?, ? )";
try
{ PreparedStatement pInsertSol = cSolCon.prepareStatement(sInsSol);
pInsertSol.setString(1, sSolNum);
pInsertSol.setString(2, sAmendNum);
pInsertSol.setString(3, sSolType );
pInsertSol.setString(4, sContractOfc );
pInsertSol.setDate(5, d );
pInsertSol.executeUpdate();
}
catch (SQLException e)
{ System.err.println("Unable to create ASFI_SOLICITATION " + e);
System.exit(1);
}

[Bill Walker]

I get an error that valueOf is not a method of java.sql.Date

[Jamie Robertson]

give this a try:

String string_date = "1999/05/22";
java.util.Date util_date;
java.sql.Date sql_date;
SimpleDateFormat sdf = new SimpleDateFormat( "yyyy/MM/dd" );
util_date = sdf.parse( string_date );
sql_date = new java.sql.Date( util_date.getTime() );
...all that java.sql stuff like above...
pInsertSol.setDate(5, sql_date );

[Bill Walker]

Thats seems to work except I don't want the time attached to it. It's just a date of birth.