[Microsoft][ODBC SQL Server Driver]Invalid date format

[Naveen Sharma]

Hi Friends
The problem is whenever i am going to Add the records in Date field of a table the error is given by the tomcat server
[Microsoft][ODBC SQL Server Driver]Invalid date format
i m using jdbc dbc bridge for connection. I have tried each and evry combination using java.util.date but all in vain. i think there is some hidden truth behind this ...... please rectify.
The Code is Following :
java.sql.Date d = new java.sql.Date(12122000);
rs_ins.updateDate("Call_Date",d);
Thanks
Naveen

[Jamie Robertson]

try using a timestamp instead.

java.sql.Timestamp d = new java.sql.Timestamp(12122000);
rs_ins.updateDate("Call_Date",d);

Jamie
[This message has been edited by Jamie Robertson (edited September 10, 2001).]