Parse Datetime to JAVA Date

Question

im getting the SQL Server datetime (1 Jan 2013) form the SqlRowSet like

while (rs.next()) {
 myBean.setDateProp(rs.getString(4));
}

the type of myBean DateProp is java.util.Date, is there a way to convert (1 Jan 2013) to java Date representation.

i have tried the following code

SimpleDateFormat sdf = new SimpleDateFormat("dd-MMM-yyyy HH:mm:ss.SSS");
Date date=new Date();        
    try {
        date = sdf.parse("1 Jan 2013");           
    } catch (Exception e) {
        e.printStackTrace();

    }

and i get the ParseException

SEVERE: java.text.ParseException: Unparseable date: "1 Jan 2013"

any directions...

i have tried the following code what happened after? have you got any exception? — Pradeep Simha
– Pradeep Simha, Commented Dec 20, 2012 at 8:01
Why are you using the format dd-MMM-yyyy HH:mm:ss.SSS when your date string looks like 1 Jan 2013? It's obvious that the format of the string isn't what you're using. — Jesper
– Jesper, Commented Dec 20, 2012 at 8:03
@Charlie i tried that but the format in SQL server db is DateTime so it throws an exception stating no date was found — Dakait
– Dakait, Commented Dec 20, 2012 at 8:05

Subhrajyoti Majumder · Accepted Answer · 2012-12-20 08:02:54Z

6

try this -

SimpleDateFormat sdf = new SimpleDateFormat("dd MMM yyyy");
Date date=new Date();        
try {
    date = sdf.parse("1 Jan 2013");           
}catch (Exception e) {
    e.printStackTrace();
}

answered Dec 20, 2012 at 8:02

Subhrajyoti Majumder

41.3k13 gold badges84 silver badges103 bronze badges

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

3 Comments

Dakait Over a year ago

that almost worked the parsing is done ok but when it is converted to java date it shows me Tue Jan 01 00:00:00 PKT 2013

Subhrajyoti Majumder Over a year ago

dont print java.util.Date object. print formatted string. lyk - System.out.println(sdf.format(date));

Dakait Over a year ago

im printing the formatted string and its printing fine but then i have to assign the value to date property of my model ...

Evgeniy Dorofeev · Accepted Answer · 2012-12-20 08:04:39Z

2

Try

while (rs.next()) {
 myBean.setDateProp(rs.getDate(4));
}

answered Dec 20, 2012 at 8:04

Evgeniy Dorofeev

137k31 gold badges209 silver badges288 bronze badges

2 Comments

Dakait Over a year ago

i tried that but the db server format is datetime so it give me the error that no date was found at index 4

Evgeniy Dorofeev Over a year ago

Sounds suspicious. Anyway, try rs.getTimestamp(4) then.

Andrzej Jozwik · Accepted Answer · 2012-12-20 08:07:49Z

2

    @Test
    public void test() throws ParseException {

        String dateString = "1 Jan 2013";
        String dateString2 = "11 Jan 2013";
        SimpleDateFormat sdf = new SimpleDateFormat("d MMM yyyy");


        sdf.parse(dateString);
        sdf.parse(dateString2);
    }

answered Dec 20, 2012 at 8:07

Andrzej Jozwik

14.8k3 gold badges61 silver badges70 bronze badges

Comments

Rahul · Accepted Answer · 2012-12-20 08:06:58Z

1

You need to modify your Date formatter string to

SimpleDateFormat sdf = new SimpleDateFormat("dd MMM yyyy");

as your date string is in this format

answered Dec 20, 2012 at 8:06

Rahul

16.4k4 gold badges44 silver badges64 bronze badges

Collectives™ on Stack Overflow

Parse Datetime to JAVA Date

4 Answers 4

3 Comments

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related