Mysql Date Format

[therenegade]

Or don't do it via the select statement and do something like this:

//some code to get the ResultSet...
Timestamp stamp = results.getTimestamp(3);//or whatever index
Date d = new Date(stamp.getTime());
SimpleDateFormat sdf = new SimpleDateFormat("dd-MM-yyyy");
String k = sdf.format(d);