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.

