Convert String Date in one format to Date object in another format

Question

I have an input date as string in format dd/MM/yyyy

Now I want to convert it into Date object having format yyyy-MM-dd

Currently I am doing

SimpleDateFormat formatter = new SimpleDateFormat("dd/MM/yyyy");
SimpleDateFormat formatter2 = new SimpleDateFormat("yyyy-MM-dd");
Date dateObject = null;
  try {
    String date2 = formatter2.format(formatter.parse(date));
    dateObject = formatter2.parse(date2);
  }

input is: "04/02/2013"

But my date object is coming out to be --> Mon Feb 04 00:00:00 IST 2013

Desired output is : 2013-02-04 (Not in string but as a date object)

I don't think you can choose how a date object is formatted. I don't know why you'd want that either. You can display it in any way you like — Toon Casteele
– Toon Casteele, Commented Apr 8, 2013 at 9:44
@Sudhanshu that's his question. Although it makes no sense, he wants to have the Date object to contain the desired string directly. — Toon Casteele
– Toon Casteele, Commented Apr 8, 2013 at 9:45
@bhuvan: convert java.util.Date to java.sql.Date and then use a setDate() method of prepared statement. Don't mess with formats! — BigMike
– BigMike, Commented Apr 8, 2013 at 9:45

NilsH · Accepted Answer · 2013-04-08 09:54:17Z

3

A date has no specific output format. When you parse your first date, that's the date. Just store it, and when you need to output it to your desired format, use the second SimpleDateFormat.

Edit:

By "store it", i mean keep a reference to it until you need it represented in your desired String format.

edited Apr 8, 2013 at 9:54

answered Apr 8, 2013 at 9:43

NilsH

13.9k4 gold badges43 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Vincent van der Weele Over a year ago

Indeed, if you use System.out.println(dateObject), it will just use the default string format, as OP observed. Printing in a custom way requires a formatter.

Rahul · Accepted Answer · 2013-04-08 09:43:59Z

1

You've already got your formatted date in date2. You needn't parse that again.

String date2 = formatter2.format(formatter.parse(date));
//dateObject = formatter2.parse(date2); // Not needed

System.out.println(date2);

answered Apr 8, 2013 at 9:43

Rahul

45.2k11 gold badges89 silver badges108 bronze badges

3 Comments

Bhuvan Over a year ago

I dont need the string. I need the date object in that format

BigMike Over a year ago

@bhuvan nope, you don't need a specific format for using Dates with JDBC

Rahul Over a year ago

as @NilsH mentioned in his answer, java.util.Date has no specific format. You can only format it to a String representation of your choice. But a Date object will always stay that way.

BigMike · Accepted Answer · 2013-04-08 09:49:03Z

1

I think you're posing the wrong question here. As stated in comments you need this string formatting for querying the database, so, since JDBC works with java.sql.Date objects, be strict to it and convert your java.util.Date object to the JDBC managed type and use it directly (without worrying about formatting).

Try something like this:

String stmt = "select field from table where dateColumn = ?";
PreparedStatement st = connection.prepareStatement(stmt);
st.setDate(1, new java.sql.Date (yourJavaUtilDateObj);
ResultSet rs = st.executeQuery();

Should work on every JDBC driver out there.

answered Apr 8, 2013 at 9:49

BigMike

6,8931 gold badge25 silver badges27 bronze badges

4 Comments

BigMike Over a year ago

Nope in comments OP stated he needs date for jdbc query, wow getting downvotes for actually reading what OP wants... amazing

NilsH Over a year ago

That would work, if the stored type is actually a date, and not just a date string.

BigMike Over a year ago

since OP wants to use a Date and says he needs a date, I guess is more than a wild guess ;).

NilsH Over a year ago

I agree, but since he wanted it in a specific format, I'm still not sure. But it's good advice anyway.

Miguel Rodrigues · Accepted Answer · 2013-04-08 09:54:10Z

0

Your Date object is correct. Date contains information about the date.

You already have the string with the date with your desired mask:

String date2 = formatter2.format(formatter.parse(date));

try:

System.out.println(date2);

answered Apr 8, 2013 at 9:54

Miguel Rodrigues

9276 silver badges19 bronze badges

Comments

Panadol Chong · Accepted Answer · 2013-10-09 03:10:33Z

0

This work for me :

public Timestamp convertStringToTimeStamp(String dateinString){
        final String OLD_FORMAT = "dd/mm/yyyy";
        final String NEW_FORMAT = "yyyy-mm-dd";

        String newDateString;

        SimpleDateFormat sdf = new SimpleDateFormat(OLD_FORMAT);
        Date d = null;
        try {
            d = sdf.parse(dateinString);
        } catch (ParseException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

        sdf.applyPattern(NEW_FORMAT);
        newDateString = sdf.format(d);

        return Timestamp.valueOf(newDateString+ " 00:00:00.00");
    }

answered Oct 9, 2013 at 3:10

Panadol Chong

1,92517 gold badges66 silver badges142 bronze badges

Collectives™ on Stack Overflow

Convert String Date in one format to Date object in another format

5 Answers 5

1 Comment

3 Comments

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

3 Comments

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related