How to Convert String To DateTime in java

Question

I am trying to store date in sql server 2005 i am used "datetime" data type in sql server and in java program i am passing string as date

ex.

String DateStr = "12/12/2013";

Date d = new Date();
java.sql.Date d1 = new java.sql.Date(d.getTime());

String sql = "INSERT INTO info (date) VALUES ( ? )";

try {
      pstmt = con.prepareStatement(sql);
      pstmt.setDate(1, d1);
      pstmt.executeUpdate();
     } catch (SQLException e) {
            System.out.println("Error:" + e);
     }

the above code is working...but i want to use String DateStr = "12/12/2013"; insted of d.getTime() bcoz i passed date as string to java function by using jquery datepicker

Rahul · Accepted Answer · 2013-11-27 06:47:46Z

7

You need to use a SimpleDateFormat to parse your String to a date and then use that date.

Date d = new SimpleDateFormat("dd/MM/yyyy").parse(DateStr); // This throws a ParseException

// Rest everything stays pretty much the same
java.sql.Date d1 = new java.sql.Date(d.getTime());
...

answered Nov 27, 2013 at 6:47

Rahul

45.2k11 gold badges89 silver badges108 bronze badges

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

3 Comments

Nilesh12 Over a year ago

Sorry For too late....It's store the current date like (thursday 28-11-2013) not DateStr

Rahul Over a year ago

the DateStr is the String holding your date. what format does it have?

Nilesh12 Over a year ago

in sql server 2005 i am using datetime as my datatype and want to store String DateStr="25/11/2013"; such string into datetime but failed

Vicky Thakor · Accepted Answer · 2013-11-27 06:59:35Z

0

public long convertLong(String value) {
    DateFormat formatter = new SimpleDateFormat("dd/MM/yyyy");
    Date getDate = null;
    long returnDate = 0l;
    try {
        getDate = (Date) formatter.parse(value);
        returnDate = getDate.getTime();
    } catch (ParseException e) {
        e.printStackTrace();
    }
    return returnDate;
}

Input: 12/12/2013 Output: 1386786600000

edited Nov 27, 2013 at 6:59

answered Nov 27, 2013 at 6:53

Vicky Thakor

3,9389 gold badges45 silver badges72 bronze badges

3 Comments

Nilesh12 Over a year ago

and how to use it to store in database

Vicky Thakor Over a year ago

Like you are doing java.sql.Date d1 = new java.sql.Date(d.getTime()); I'm not sure but will work. I just gave you solution for getting d.getTime() from your dd/MM/yyyy

Vicky Thakor Over a year ago

Have you tried like java.sql.Date d1 = new java.sql.Date(convertLong("12/12/2013")) ?

Damodaran · Accepted Answer · 2013-11-27 07:24:27Z

0

First convert string in datetime object than you can directly pass d1 to your code

String DateStr = "12/12/2013";
DateTimeFormatter formatter = DateTimeFormat.forPattern("dd/MM/yyyy ");
DateTime dt = formatter.parseDateTime(DateStr);
String sql = "INSERT INTO info (date) VALUES ( dt )";
try {
      pstmt = con.prepareStatement(sql);
      pstmt.setDate(1, d1);
      pstmt.executeUpdate();
     } 
catch (SQLException e) {
            System.out.println("Error:" + e);
     }

edited Nov 27, 2013 at 7:24

Damodaran

11.1k10 gold badges62 silver badges83 bronze badges

answered Nov 27, 2013 at 6:55

user3040553

1

2 Comments

Nilesh12 Over a year ago

Thanx for replying but it shows 'java.lang.IllegalArgumentException: Invalid format: "28/11/2013" is too short'

Nilesh12 Over a year ago

and if i use pstmt.setDate(1, dt); it shows 'DateTime CanNot be converted to Date'

Collectives™ on Stack Overflow

How to Convert String To DateTime in java

3 Answers 3

3 Comments

3 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related