con = DriverManager.getConnection(SERVER, USERNAME, PASSWORD);
st = con.createStatement();
// Формат в Java
rs = st.executeQuery("select sysdate from dual");
 if  (rs.next()) {
  Date date = rs.getDate("sysdate");
  SimpleDateFormat dateFormatter =  new  SimpleDateFormat("dd.MM.yyyy");
  String result = dateFormatter.format(date);
  System.out.println(result);
}
// Формат в Oracle
rs = st.executeQuery("select to_char(sysdate, 'dd.mm.yyyy') system_date from dual");
 if  (rs.next()) {
  String result = rs.getString("system_date");
  System.out.println(result);
}