SimpleDateFormatter.parse giving output in different format than specified

by

Don’t pass dates as strings to your MySQL database. It’s better, both easier and safer to pass date objects. For one thing, it relieves you of formatting and any formatting issues. Best, pass instances of a class from java.time, the modern Java date and time API. In your case a LocalDateTime will do.

    String ep ="a1527069600";
    long epoch = Long.parseLong(ep.substring(1));
    Instant inst = Instant.ofEpochSecond(epoch);
    LocalDateTime ldt = inst.atZone(ZoneId.of("Asia/Calcutta")).toLocalDateTime();

    System.out.println(ldt);

    PreparedStatement ps = myDatabaseConnection.prepareStatement(
            "insert into my_table (my_date_time) values (?)");
    ps.setObject(1, ldt);

The LocalDateTime obtained is:

2018-05-23T15:30

I simplified your conversion from epoch string a bit. Use a primitive, lowercase long rather than a Long object. I am using your time zone, Asia/Calcutta, assuming that your database values are in this time zone. Normal recommendations are to keep database values in UTC, at least if there’s any possibility that the data will ever be used outside your time zone. If you want this, use this conversion instead of the one above:

    LocalDateTime ldt = inst.atOffset(ZoneOffset.UTC).toLocalDateTime();

Link: Oracle tutorial: Date Time explaining how to use java.time.

More Related Contents:

  1. MySQL query to get Records in Result set
  2. How to get UTF-8 working in Java webapps?
  3. MySQL JDBC Driver 5.1.33 – Time Zone Issue
  4. Using “like” wildcard in prepared statement
  5. Android JDBC not working: ClassNotFoundException on driver
  6. MySQL and JDBC with rewriteBatchedStatements=true
  7. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  8. Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client
  9. “Loading class com.mysql.jdbc.Driver … is deprecated” message
  10. Unable to get spring boot to automatically create database schema
  11. Hibernate: Automatically creating/updating the db tables based on entity classes
  12. Returning a ResultSet
  13. How to change MySQL timezone in a database connection using Java?
  14. How to configure Tomcat to connect with MySQL
  15. Java JDBC MySQL exception: “Operation not allowed after ResultSet closed”
  16. java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname [duplicate]
  17. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure Software caused connection abort: recv failed [duplicate]
  18. Convert BufferedInputStream into image [duplicate]
  19. how to get list of Databases “Schema” names of MySql using java JDBC
  20. Access denied for user ‘root’@’localhost’
  21. Invalid syntax error “type= MyISAM” in DDL generated by Hibernate
  22. Is there a way to retrieve the autoincrement ID from a prepared statement
  23. Why can Java not connect to MySQL 5.7 after the latest JDK update and how should it be fixed? (ssl.SSLHandshakeException: No appropriate protocol)
  24. Easiest way to convert a Blob into a byte array
  25. No matter what, I can’t batch MySQL INSERT statements in Hibernate
  26. com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source
  27. How to use prepared statement for select query in Java?
  28. A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)
  29. How to connect to a remote MySQL database with Java?
  30. A persistent connection with JDBC to MySQL

Leave a Comment