Hi, I am using a SQL Server stored proc.I am trying to update a smalldatetime column and get the error "error converting datetime to smalldatetime". Another smalldatetime column in the table has the format "yyyy-mm-dd hh:mm:ss". I tried the foll code: long i = drvo.getDateOfBirth().getTime();//getDateOfBirth returns a java.util.Date call.setDate(1,new java.sql.Date(i)); //call.setTimestamp(1,new java.sql.Timestamp(i)); Using both the setDate and setTimestamp gave me the same error.I am using the sql server type 4 driver for 7.0.I tried using Resultsetmetadata and got the column type to be Timestamp from the table.Its defined as smalldatetime in the table. Thanx in advance for any help, Vijay