1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
|
String sql = "SELECT * FROM orders ORDER BY order_number desc";
PreparedStatement statement = conn.prepareStatement(sql);
ResultSet rowsselected = statement.executeQuery();
Date datedepartd = rowsselected.getDate("datedepart");
Date datearrived = rowsselected.getDate("datearrive");
DateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy HH:mm");
// converting the util date into string format
final String datedepart = dateFormat.format(datedepartd).toString();
final String datearrive = dateFormat.format(datearrived).toString(); |