Convert String to SQL Date

Question

I have a String which contains date string eg 12-28-18 of format MM-dd-yy. I wish to pass this parameter to a stored procedure in Oracle database.

Hence, I am trying to convert this String to java.sql.Date. Following is the method I am following to convert:

DateFormat df = new SimpleDateFormat("MM-dd-yy");
java.util.Date date1 = df.parse(valueobject.getDate());
java.sql.Date date2 = new java.sql.Date(date1.getTime())

However , it leads to ParseException. Not able to figure out why it fails during parsing. Any help on this would be great!

Tried this: new SimpleDateFormat("MM-dd-yy", Locale.ENGLISH).parse("12-28-18"); but no exception thrown. — johnchen902
– johnchen902, Commented Jul 15, 2013 at 5:54
Is valueobject.getDate() a String? Just to double check. I've seen someone accidentally try to parse a date into a date. — Mark M
– Mark M, Commented Jul 15, 2013 at 5:56

k_rollo · Accepted Answer · 2015-12-06 21:08:11Z

6

Using valueOf():

String date = "2000-11-01"; // YYYY-MM-DD
java.sql.Date sqlDate = java.sql.Date.valueOf(date);

edited Dec 6, 2015 at 21:08

answered Nov 23, 2014 at 4:41

k_rollo

5,49217 gold badges69 silver badges98 bronze badges

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

Comments

Ruchira Gayan Ranaweera · Accepted Answer · 2013-07-15 06:00:04Z

0

Try this

    DateFormat df = new SimpleDateFormat("EEE MM-dd-yy hh:mm:ss");
    Date d=new Date();
    String date1 = df.format(d);
    java.sql.Date date2 = new java.sql.Date(d.getTime());
    System.out.println(date1);
    System.out.println(df.format(date2));

Or

    DateFormat df = new SimpleDateFormat("MM-dd-yy");
    Date d=new Date();
    String date1 = df.format(d);
    java.sql.Date date2 = new java.sql.Date(d.getTime());
    System.out.println(date1);
    System.out.println(df.format(date2));

answered Jul 15, 2013 at 6:00

Ruchira Gayan Ranaweera

35.7k17 gold badges78 silver badges117 bronze badges

Comments

Nguyen Giang · Accepted Answer · 2013-07-15 06:27:29Z

0

This work for me, maybe yourvalueobject.getDate() doesn't return a String. Please check!!

SimpleDateFormat format = new SimpleDateFormat("MM-dd-yyyy");
    Date parsed = format.parse("07-15-2013");
    java.sql.Date sql = new java.sql.Date(parsed.getTime());

Similar with your code and work very well!

answered Jul 15, 2013 at 6:27

Nguyen Giang

237 bronze badges

Collectives™ on Stack Overflow

Convert String to SQL Date

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related