Date type typecasting

Refer to the following url

http://forum.java.sun.com/thread.jspa?threadID=679914&messageID=3965390

This requires more than a typecast. You need to tell the system what format the date is in. To do this you use a DateFormat object. Usually, when reading dates, you use a SimpleDateFormat, which allows you to supply a pattern string, indicating how the variious components are organised. Date.parse gives you a result of type java.util.Date.

Unfortunately for JDBC you need a java.sql.Date object, so you need another stage of coversion.

You should study the Javadocs for DateFormat and SimpleDate format.

But basically you do something like this:

DataFormat df = new SimpleDateFormat("dd/MM/yyyy");
try {
java.util.Date date = df.parse(dateStr);
java.sql.Date sqlDate = new java.sql.Date(date.getTime());
} catch(ParseException e) {
.. deail with invalid date format here
}