Syntax error converting datetime from character string.

[S bitz]

Hi,
I am trying to insert some values in a database.I'm using prepared statements and this is my query

  
 

            conn  = super.getConnection ();
            pstmt = conn.prepareStatement (sbInsertQuery.toString ());
            pstmt.setInt (1,i);
            pstmt.setString (2,getHeaderId (username,conn));
            pstmt.setString (3,reqLeave.getLeaveType ());
            [B]pstmt.setString (4,startDate.trim ());
            pstmt.setString (5,returnDate.trim ());[/B]
            
            pstmt.setString (6,reqLeave.getNumberOfDays());
            pstmt.setString (7,reqLeave.getLeavePurpose ());
            pstmt.setString (8,reqLeave.getContactAddress ());
            pstmt.setString (9,reqLeave.getContactNumber ());         
            

startDate and returnDate are of the format "YYYYMMDD"

This throws this error : Syntax error converting datetime from character string.

but when i change the query to

pstmt.setString(4,"20060905") this works fine.

I'm using SQL Server 2000.
Can anyone tell me how this can be fixed?

Thanks
Bitz

[Shailesh Chandra]

Convert Your String date to java.util.Date or Java.sql.Date

Set them as date in preparedStaement, NOT as String

 pstmt.setDate(4,startDateObject);
 pstmt.setDate(5,returnDateObject);

Shailesh