I have a String s date in following format 05-10-2020
I want to convert this String to Date in following format dd-MM-yyyy
so I can use it in below query for my Sqlite db
SimpleDateFormat simpledateformat = new SimpleDateFormat("dd-MM-yyyy");
String s = app.getDate(); // returns "05-10-2020"
Date date = simpledateformat.parse(s);
String selectQuery = "SELECT * FROM User Where Date !=" + date;
But date is returns date in follwoing format Mon Oct 05 00:00:00 GMT+03:00 2020
You should use PreparedStatement with LocalDate as this:
LocalDate ld = LocalDate.parse(app.getDate(),DateTimeFormatter.ofPattern("dd-MM-uuuu"));
String selectQuery = "SELECT * FROM User Where Date != ?";
try (PreparedStatement ps = con.prepareStatement(selectQuery)) {
ps.setObject (1, ld);
// ...
} catch (SQLException e) {
e.printStackTrace();
}
You should use prepared statements for RDBMS work. From your third line on, try:
PreparedStatement selectQuery = connectionObj.prepareStatement("SELECT * FROM User Where Date != ?");
selectQuery.setDate(1, date);
ResultSet res = selectQuery.executeQuery();
res.next();
// manipulate the resultset to your heart's content
It will provide a lean solution. You can dynamically adjust it to your code.
String dateStr = "Mon Oct 05 00:00:00 GMT+03:00 2020";
DateFormat formatOne= new SimpleDateFormat("E MMM dd HH:mm:ss Z yyyy");
DateFormat formatSecond= new SimpleDateFormat("dd-MM-yyyy");
System.out.println(formatSecond.format(formatOne.parse(dateStr)));
You can use it at the relevant place in your project.
simpledateformat.format(s);, just a thoughtSimpleDateFormatand friends. See if you either can use desugaring or add ThreeTenABP to your Android project, in order to use java.time, the modern Java date and time API. It is so much nicer to work with.