Hi,
I am trying to insert some values in a database.I'm using prepared statements and this is my query
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