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

passing Date through Select query .

 
Vikram Deshmukh
Greenhorn
Posts: 29
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear freinds ,
While i was inserting cells in the table i was used to insert date in the form of
String with desired format of a date . it worked .
But while i'm going to Query having date in the where clause, it is giving me Runtime
error like Data type mismatch in criteria expression. I'm passing date in the String format
only.
I also worked with converting it to java.sql.Date format. It gave me Runtime error like,
IllegalArgumentExpression .
can anybody tell how to send a date through Select query, through JDBC ?
from ,
vikram .
 
Carl Trusiak
Sheriff
Posts: 3341
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

I hope this is helpful

[This message has been edited by Carl Trusiak (edited July 11, 2000).]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic