“EEE MMM dd HH:mm:ss ZZZ yyyy” date format to java.sql.Date

by 
    LocalDate date4 = ZonedDateTime
            .parse(date, DateTimeFormatter.ofPattern("EEE MMM dd HH:mm:ss zzz yyyy", Locale.ENGLISH))
            .toLocalDate();
    java.sql.Date date5 = java.sql.Date.valueOf(date4);

I am using the modern classes in the java.time package. You notice that the code is not only simpler, once you get acquainted with the fluent writing style of the newer classes, it is also clearer.

If you wanted to be 100 % modern, you should also check out whether your latest MySQL JDBC driver wouldn’t accept a LocalDate directly without conversion to java.sql.Date. It should.

A few details to note

  • If you need your code to run on computers outside your control, always give locale to your formatter, or your date string cannot be parsed on a computer with a non-English-speaking locale. You may use Locale.ROOT for a locale neutral locale (it speaks English).
  • If you can, avoid the three letter time zone abbreviations. Many are ambiguous. EET is really only half a time zone since some places where it’s used are on EEST (summer time) now. Better to use either a long time zone ID like Europe/Bucharest or an offset from UTC like +02:00.

These points are valid no matter if you use DateTimeFormatter or SimpleDateFormat.

If you cannot or do not want to move on to the recommended newer classes, the fix to your code is:

    SimpleDateFormat formatnow 
            = new SimpleDateFormat("EEE MMM dd HH:mm:ss zzz yyyy", Locale.ENGLISH); 
    SimpleDateFormat formatneeded = new SimpleDateFormat("yyyy-MM-dd");

I am using lowercase zzz since this is documented to match a three-letter time zone name, I know that uppercase ZZZ works too. I have added locale. And maybe most importantly, in the needed format I have changed YYYY (week-based year) to yyyy (calendar year) and DD (day of year) to dd (day of month). All those letters are in the documentation.

More Related Contents:

  1. Hours and seconds are lost when storing a date in the database [closed]
  2. How do I get a result across 2 tables
  3. Multiple queries executed in java in single statement
  4. How to convert java.util.Date to java.sql.Date?
  5. Dates with no time or timezone component in Java/MySQL
  6. Insert & fetch java.time.LocalDate objects to/from an SQL database such as H2
  7. java.util.Date vs java.sql.Date
  8. Handling MySQL datetimes and timestamps in Java
  9. MySQL and JDBC with rewriteBatchedStatements=true
  10. right syntax to use near ‘?’
  11. Running a .sql script using MySQL with JDBC
  12. Prevent SQL injection attacks in a Java program
  13. Java Date – Insert into database
  14. handling DATETIME values 0000-00-00 00:00:00 in JDBC
  15. LINQ for Java tool [closed]
  16. java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname [duplicate]
  17. Timezones in SQL DATE vs java.sql.Date
  18. How to use prepared statement for select query in Java?
  19. A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)
  20. Hibernate Criteria API: get n random rows
  21. Getting last record from mysql
  22. MySQL query to get Records in Result set
  23. How do I get the size of a java.sql.ResultSet?
  24. Hibernate: Automatically creating/updating the db tables based on entity classes
  25. Convert BufferedInputStream into image [duplicate]
  26. Hibernate Group by Criteria Object
  27. Access denied for user ‘root’@’localhost’
  28. Is there a more efficient way of making pagination in Hibernate than executing select and count queries?
  29. Date vs TimeStamp vs calendar?
  30. How to avoid OOM (Out of memory) error when retrieving all records from huge table?

Leave a Comment