Date

[satishind Reddy]

Hi,
I have a table in Microsoft SQL data base. In that table one field is a Date field. I am getting error while inserting record. I am giving code snippet please help me. what am I doing wrong here.

      a.util.Date date = new java.util.Date();
      SimpleDateFormat fmt = new SimpleDateFormat ("MM/DD/YYYY");
      String dtstr = fmt.format(date);
      try{
 fmt.setLenient(true);
 todate = fmt.parse(dtstr);
      }catch(ParseException pe){
msgout.append("Date Format problem\n" );
      }
      String query = "INSERT INTO orders " +
             "(ordno,id,OrderDate,cake,naan,bagel,wheat)"                
             +"VALUES ("+forno+","+ screenvar.id.getText()    
                + ",'" + todate+ "'," + 
                  String.valueOf(icake) + "," + 
                  String.valueOf(inaan)  + "," +
  String.valueOf(ibagel)  + "," + 
                  String.valueOf(iwheat) + ")";

Thanks in advance.
Regards
Satish


[This message has been edited by Thomas Paul (edited December 07, 2000).]

[Thomas Paul]

Parsing the date in this way will simply remove the portions of the date that are not year-month-day but will not effect what is passed to the datatbase which is: 'Thu Dec 07 00:00:00 EST 2000'.
You need to use the SimpleDateFormat to convert the Date object into a String. Try this:
SimpleDateFormat fmt = new SimpleDateFormat ("MM/dd/yyyy");
String todate = fmt.format(date);

[satishind Reddy]

Hi Thomas,
Thanks for reply. Still it is giving problem because in table level my date field data type is 'datetime'.
SimpleDateFormat fmt = new SimpleDateFormat ("MM/dd/yyyy");
String todate = fmt.format(date);
here 'todate' is string. and table level field data type is 'datetime'. so it is giving data mismatch error.
please help to me. If i am not clear i can send code if u provide mail id.
Thanks
Satish

[Thomas Paul]

All you have to do is figure out what is a valid String format that MS SQL will accept in a date/time field and then use SimpleDateFormat to reproduce that format.

[maha anna]

Hi Reddy,
The following is the code snippet which I use in My-SQL and Access. It may not be same in MS-SQL. You can try it. Otherwise please look into the documentation. In the foll. code the DOB(DateOfBirth) String has to be in yyyymmdd format
regds
maha anna

String cmdStr ="INSERT into Employees (EmpNo,Password,EmpFirstName,EmpMdleName,EmpLastName,BaseBranch,DOB,
Desgn,SSN,WorkPhone,HomePhone,WorkFax,EMail,PptNo,PptExpiry,LastUpdDate,LastUpdBy) " + " values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
registerStatement = dbConnection.prepareStatement(cmdStr);
registerStatement.setDate(7,java.sql.Date.valueOf(DOB));

[This message has been edited by Thomas Paul (edited December 08, 2000).]

[satishind Reddy]

Hi paul,
Paul i havn't noticed that 'MM' should be Caps otherwise it is taking minutes insted of month. Due to this i got error every time.
Thanks for all your replies.
Satish

[Thomas Paul]

That will make a difference. Glad that your problem is solved!