Conversion

[Ramesh Pappala]

I got the date value from the html file to my servlet by using the below code,

hiredate=req.getParameter("hiredate");

how to convert this hiredate into "SQL DATE" type. (ORACLE)

Please give an example code.

[Bear Bibeault]

SQL date conversion isn't a servlets-specific topic, so I'm moving this off to the JDBC forum.

[Paul Clapham]

SimpleDateFormat sdf = new SimpleDateFormat("something");
try {
  java.util.Date uDate = sdf.parse(hiredate);
  java.sql.Date sDate = new java.sql.Date(uDate.getTime());
} catch(NumberFormatException nfe) {
  // Date wasn't in the right format, do something about that
}

I will let you check the API documentation pages to find out what "something" should be for whatever date format you expect to be receiving.

[Ramesh Pappala]

Thank You Paul Clapham, for giving reply to my question. And the answer you have given is working.
Once again thanks for giving reply.