• Post Reply Bookmark Topic Watch Topic
  • New Topic

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

 
Naveen Sharma
Ranch Hand
Posts: 65
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
try using a timestamp instead.

Jamie
[This message has been edited by Jamie Robertson (edited September 10, 2001).]
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!