Converting MySQL date format in Java

Question

I am touching Java for the very first time here, so go easy on me. I am having to correct someone else's older code. This java program takes data from a MySQL table and prepares it for presentation on web pages. I found that their MySQL table for some reason used INT fields for all the dates. So, for instance, today's date is stored as the INT 3222017. I first had to add the proper DATE columns to the MySQL table. Next I re-did another Java script to pull the data from a larger table for the MySQL table that this script will be using.

Now I need to change the code that currently formats the INT fields into MM/dd/yyyy to instead take the DATE fields (stored as yyyy-MM-dd) and convert them to the same MM/dd/yyyy.

Here is a piece of the code that uses the function dateFormat on the INT fields -

String formattedDate = "";

            formattedDate = dateFormat(oneSpectro.getSpectroLastDate());
            result.setSpectroLastDate(formattedDate);

            formattedDate = dateFormat(oneSpectro.getSpectroOrigDate());
            result.setSpectroOrigDate(formattedDate);

            formattedDate = dateFormat(oneSpectro.getSpectroCalDate());
            result.setSpectroCalDate(formattedDate);
            }

        return result;
    }

And here is the dateFormat function -

public String dateFormat(int theDate){
        String      dateString = "";
        Integer     dateInt = 0;

        if (theDate < 10000000){
            dateInt = new Integer(theDate);
            dateString = dateInt.toString();
            // Add preceding 0 to make the date 8 digits in length.
            dateString  = "0" + dateString;

        }
        else {
            // Process an 8 digit date.
            dateInt = new Integer(theDate);
            dateString = dateInt.toString();
        }
        // Install date slashes in the date string.
        if (dateString.length() == 8){
            dateString = dateString.substring(0, 2) + "/" + dateString.substring(2, 4) + "/" 
                    + dateString.substring(4);
        }
        return dateString;
    }

How do I go about converting a DATE field (yyyy-MM-dd) to a formatted date of MM/dd/yyyy?

Answer 1

You can convert String to Date util:

 DateFormat format = new SimpleDateFormat("yyyy-MM-dd", Locale.ENGLISH);
 Date date = format.parse(your string);

And then convert the Date object to your String format:

 DateFormat df = new SimpleDateFormat("MM/dd/yyyy");
 String result = df.format(date);

Answer 2

tl;dr

LocalDate.parse(                               // Use modern java.time classes rather than troublesome legacy date-time classes
    String.format("%08d", 3222017) ,           // Let Java pad with leading zero.
    DateTimeFormatter.ofPattern( "MMdduuuu" )  // Parse string as a `LocalDate`.
)

2017-03-22

DATE column type

That is one ridiculously bad way to store a date value.

When storing date data, one should use a date datatype when defining the database column.

You should not be using integers nor strings for moving this data in and out of your database. Let your JDBC driver do its job, transmitting java.time.LocalDate objects to/from your database’s column defined as a date datatype. In MySQL that would be the DATE type.

If your JDBC driver complies with JDBC 4.2 or later, use the PreparedStatement::setObject and ResultSet::getObject methods to pass & get a java.time.LocalDate object. For older drivers, convert the java.time types to the legacy java.sql types such as java.sql.Date. Look for new methods added to the old classes for conversion.

java.sql.Date sqlDate = java.sql.Date.valueOf( myLocalDate );

Going the other direction.

LocalDate localDate = myJavaSqlDate.toLocalDate();

java.time

The other Answers use the troublesome old legacy date-time classes. Those are now legacy, supplanted by the java.time classes.

The LocalDate class represents a date-only value without time-of-day and without time zone.

The format YYYY-MM-DD for dates is defined in the ISO 8601 standard. The java.time classes use the standard formats by default. So no need to specify a formatting pattern.

LocalDate localDate = LocalDate.parse( "2017-03-22" );

To parse your funky pseudo-integer string, define a formatting pattern to match.

DateTimeFormatter f = DateTimeFormatter.ofPattern( "MMdduuuu" );

To generate that string from the integer, you can shorten that existing code of yours by letting Java pad with leading zero.

String input = String.format("%08d", 3222017) ;

03222017

Parse that input using the DateTimeFormatter to produce a LocalDate object.

LocalDate localDate = LocalDate.parse( input , f );

localDate.toString(): 2017-03-22

See this code run live at IdeOne.com.

---

About java.time

The java.time framework is built into Java 8 and later. These classes supplant the troublesome old legacy date-time classes such as java.util.Date, Calendar, & SimpleDateFormat.

The Joda-Time project, now in maintenance mode, advises migration to the java.time classes.

To learn more, see the Oracle Tutorial. And search Stack Overflow for many examples and explanations. Specification is JSR 310.

Where to obtain the java.time classes?

• Java SE 8 and SE 9 and later
  • Built-in.
  • Part of the standard Java API with a bundled implementation.
  • Java 9 adds some minor features and fixes.
• Java SE 6 and SE 7
  • Much of the java.time functionality is back-ported to Java 6 & 7 in ThreeTen-Backport.
• Android
  • The ThreeTenABP project adapts ThreeTen-Backport (mentioned above) for Android specifically.
  • See How to use ThreeTenABP….

The ThreeTen-Extra project extends java.time with additional classes. This project is a proving ground for possible future additions to java.time. You may find some useful classes here such as Interval, YearWeek, YearQuarter, and more.

Answer 3

    try {
        String dateString = "2017-03-22";

        // convert string to date
        SimpleDateFormat f = new SimpleDateFormat("yyyy-MM-dd");
        Date date = f.parse(dateString);

        // change the date format
        SimpleDateFormat df = new SimpleDateFormat("MM/dd/yyyy");
        String result = df.format(date);

    } catch(ParseException e) {
        throw new RuntimeException(e);
    }

Joao's solution works. A few gotchas:

• In my compiler I couldn't convert DateFormat to SimpleDateFormat. I stuck with using the SimpleDateFormat object.
• My compiler enforces a use of a try-catch block. A try catch block is needed in case it can't convert from String to SimpleDateFormat. If it can't parse, log an error with a ParseException.

I hope this helps.