This week's book giveaway is in the Agile and Other Processes forum.
We're giving away four copies of The Little Book of Impediments (e-book only) and have Tom Perry on-line!
See this thread for details.
Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • 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).]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic