aspose file tools
The moose likes JDBC and the fly likes How to use to_date in preparedstatement Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "How to use to_date in preparedstatement" Watch "How to use to_date in preparedstatement" New topic
Author

How to use to_date in preparedstatement

Mohan Reddy
Greenhorn

Joined: Feb 10, 2006
Posts: 21
posted private message
0
Quote
hi,
Please help me to use to_date function in PreparedStatement as its showing error....



thanks in advance

cheers<br /> <br />mohan.<br /> <br /><br />Always do what you are afraid to do...
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

I like...
Eclipse IDE Hibernate Java
posted private message
0
Quote
Why are you using to_date with a PreparedStatement? Could you not just bind the date parameter (i.e. with setDate())?

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Mohan Reddy
Greenhorn

Joined: Feb 10, 2006
Posts: 21
posted private message
0
Quote
Thanks Mr. Paul..

I got succeeded.
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: How to use to_date in preparedstatement
 
Similar Threads
Oracle date-time fields
Converting String to Date???
Update query
error of missing values
sql exception when try to get date