Class java.sql.Date

[Vaskar Dasgupta]

CAN ANYONE HELP OUT WITH THIS ???
java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat("mmm dd yyyy hh:mm a");
java.util.Date dt = new java.util.Date();
String dtStr = formatter.format(dt);
java.sql.Date objDt = new java.sql.Date.valueOf(dtStr);
cStmt.setDate(2,objDt); (cStmt is an object of Callable Statement)
THE ABOVE CODE WHEN COMPILED GIVES THE FOLLOWING COMPILER ERROR(FYI I AM USING JDK1.2.2)
Class java.sql.Date. valueOf not found. java.sql.Date objDt = new java.sql.Date.valueOf(dtStr);
^
1 error

[David Peterson]

java.sql.Date objDt = new java.sql.Date.valueOf(dtStr);

The above code is trying to instantiate a class called "valueOf" in the java.sql.Date package. You're missing some brackets! This is what you need:

java.sql.Date objDt = new java.sql.Date().valueOf(dtStr);

Out of interest, if all you're trying to do is set the parameter in the callable statement to the current date/time, you could simplify it down to one line:

cStmt.setDate(2,new java.sql.Date());

David

[Chidda Nana]

valueOf method in java.sql.Date is not an instance method. It is a static method.
java.sql.Date objDt = new java.sql.Date.valueOf(dtStr);
replace the line with the line dispalyed below and it should be fine
java.sql.Date.valueOf(dtStr);
Chidda