set date TO_DATE() in preparedstatement

Hi,

PG_DATE is date field in master table in oracle database and is recieved by setxxx and getxxx method in bean.

I want to set it with preparedstatement like -

pstmt.setString(4,TO_DATE(PG_DATE,"DD-MM-YYYY"));

it gives error -

symbol : method TO_DATE(java.lang.String,java.lang.String)

location: class dbbean.addcontentbean

pstmt.setString(4,TO_DATE(PG_DATE,"DD-MM-YYYY"));

how can i pass it with preparedstatement.

[472 byte] By [pvanjavaa] at [2007-11-26 15:47:51]
# 1
If you want to set a Date use the setDate function on the prepred statementpstmt.setDate(4,yourDate;
pgeuensa at 2007-7-8 22:07:17 > top of Java-index,Java Essentials,New To Java...