Скачать или смотреть How to Get java.sql.Date in a Specific Format

Learn how to format `java.sql.Date` to a specific style easily in Java. This guide walks you through the steps needed to convert date formats without hassle!
---
This video is based on the question https://stackoverflow.com/q/68406426/ asked by the user 'anand' ( https://stackoverflow.com/u/2775139/ ) and on the answer https://stackoverflow.com/a/68406649/ provided by the user 'Egan Wolf' ( https://stackoverflow.com/u/5722505/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: How to Get java.sql.Date in particular Format only

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
How to Get java.sql.Date in a Specific Format

When working with dates in Java, it can often be challenging to get them in the format you desire. One common problem that developers face is how to convert date formats while using java.sql.Date. In this post, we will walk through a practical example of how to transform a date from one format to another and ensure you get the output in the exact specification you need.

Understanding the Problem

We have a requirement where we need to convert a date from the format MM/dd/yyyy (e.g., 01/01/2020) to dd-MM-yy (e.g., 01-01-20). The challenge lies in effectively handling this transformation, especially when dealing with java.sql.Date, which defaults to an output format of yyyy-MM-dd.

The Solution: Steps to Convert Date Formats

Step 1: Setup the Input and Output Formats

We will start by defining the formats for our input and output dates using the SimpleDateFormat class.

[[See Video to Reveal this Text or Code Snippet]]

Here:

orgFormat is used to parse the initial string date.

targetFormat is intended for formatting the parsed date into the desired format.

Step 2: Parse the Input Date

Next, we parse the string date using the input format.

[[See Video to Reveal this Text or Code Snippet]]

If the parsing is successful, inputDate will hold a valid java.util.Date object representing the specified date.

Step 3: Format the Date to Desired Output

After we have the inputDate, we will format it into our desired style.

[[See Video to Reveal this Text or Code Snippet]]

Step 4: Convert to java.sql.Date

Now, we can convert our formatted date into a java.sql.Date.

[[See Video to Reveal this Text or Code Snippet]]

Step 5: Correct Output Format

When we print directly from the sqlDate, we see it defaults to yyyy-MM-dd format. To display it in our desired format, we utilize targetFormat again for formatting.

[[See Video to Reveal this Text or Code Snippet]]

Complete Code Example

Here's how the entire code will look:

[[See Video to Reveal this Text or Code Snippet]]

Conclusion

By following the outlined steps, you can successfully convert and format a java.sql.Date to meet your output requirements. This conversion ensures that dates are displayed exactly as needed, facilitating easier debugging and better readability in your applications.

Now go ahead, implement these changes, and see how simple it can be to manage date formats in Java!