Localdate.format, format is not applied

by

Don’t format your date for insertion into your SQL database. Assuming that your database column has datatype date and you are using at least Java 8 and at least JDBC 4.2, just pass the LocalDate to your PreparedStatement as it is:

    PreparedStatement insertStmt = myConnection.prepareStatement(
            "insert into my_table(purchase_date) values (?)");
    insertStmt.setObject(1, purchaseDate);

Your JDBC driver will take care of the rest. If using JPA, your JPA implementation will take care of it too.

If your column has char type (for example varchar(10)) and you cannot change it, don’t invent your own format for it. Store the date in ISO 8601 format. LocalDate.toString() produces this format.

    String formattedDate = purchaseDate.toString();
    System.out.println(formattedDate);

In my case output was:

2017-11-29

As an aside, for presentation to your user you shouldn’t invent your own format either. Rather rely on the built-in formats in Java. For example:

    Locale turkish = Locale.forLanguageTag("tr");
    DateTimeFormatter dateFormatter = DateTimeFormatter.ofLocalizedDate(FormatStyle.SHORT)
            .withLocale(turkish);
    String formattedDate = purchaseDate.format(dateFormatter);
    System.out.println(formattedDate);

Output:

29.11.2017

What went wrong in your code?

There are two things wrong:

  1. You used lowercase mm. This means minute of hour, and since a LocalDate doesn’t have a time of day in it, it threw the exception you saw. The message you got is pretty precise:

Unsupported field: MinuteOfHour

Instead you may use uppercase MM for two-digit month.

  1. You need to pick up the format in the String returned from the format method. The LocalDate is immutable and therefore not affected by the method call. Also it cannot have a format in it. It’s just a date in the calendar.

Links

More Related Contents:

  1. How to reference javafx fxml files in resource folder?
  2. JavaFX 2.1 TableView refresh items
  3. javafx automatic resizing and button padding
  4. How to create an FXML file for an already created new component in java than add it to scene builder?
  5. javafx using objects from MainController or other Controllers in proper Controller class
  6. JavaFX Nested Controllers (FXML )
  7. How do I access a UI element from another controller class in JavaFX?
  8. How to use font awesome in a fxml project (javafx)
  9. Grouping together JavaFX FXML Objects
  10. JavaFX – setVisible hides the element but doesn’t rearrange adjacent nodes
  11. getHostServices().showDocument() in a FXML File
  12. How to switch scenes in JavaFX
  13. JavaFX: Change application language on the run
  14. Java FX fxml on Action
  15. How to create multiple javafx controllers with different fxml files?
  16. How to determine day of week by passing specific date?
  17. JavaFX and OpenJDK
  18. “EEE MMM dd HH:mm:ss ZZZ yyyy” date format to java.sql.Date
  19. java date problem in parsing
  20. How to properly format the date?
  21. How show specific part of an image in javafx
  22. Java Timestamp – How can I create a Timestamp with the date 23/09/2007?
  23. Implement tags bar in JavaFX
  24. JavaFX Error when trying to make Tableview Clickable
  25. Performance of WebView in JavaFX
  26. java: how to mock Calendar.getInstance()?
  27. Date vs TimeStamp vs calendar?
  28. Setting font color of JavaFX TableView Cells?
  29. Why can’t OffsetDateTime parse ‘2016-08-24T18:38:05.507+0000’ in Java 8
  30. Get Daylight Saving Transition Dates For Time Zones in Java

Leave a Comment