java.text.parseException: unparseable date 1994-09-09 [duplicate]

Question

I am trying to send a date value from my java program into an oracle sql database. But I keep getting the error: java.text.parseexception: unparseable date.

I set the date format as:

SimpleDateFormat df = new SimpleDateFormat("yyyy/MM/dd", Locale.ENGLISH);
        java.sql.Date date = (java.sql.Date)df.parse(dob_text.getText());

I have set my database with the same date format. And try to send the date through a prepared statement like so:

ps.setDate(3, date);

I am entering a date 1994-09-09. That's the correct date format for the one I declared right? Is there something wrong with my java formation code? Has anyone else had this problem? Any help would be much appreciated

Your format uses front slashes (/), but your date has dashes (-). — sstan
– sstan, Commented Dec 12, 2015 at 22:40
The first element of the Question is also a duplicate of this and many many others. Please search StackOverflow.com before posting. — Basil Bourque
– Basil Bourque, Commented Dec 13, 2015 at 4:38
FYI, the terribly troublesome old date-time classes such as java.util.Date, java.sql.Date, and java.text.SimpleDateFormat are now legacy, supplanted by the java.time classes built into Java 8 and later. See Tutorial by Oracle. — Basil Bourque
– Basil Bourque, Commented Dec 31, 2018 at 2:33

Community · Accepted Answer · 2017-05-23 12:15:47Z

1

This should work, I corrected 2 errors :

First of all, the format should have been yyyy-MM-dd since that's the format of your input.
Then, you can not implicitely cast java.util.Date to java.sql.Date, you need to use the java.sql.Date constructor and java.util.Date#getTime(). See here

Solution

SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd", Locale.ENGLISH);
java.sql.Date SQLDate = new java.sql.Date(df.parse(dob_text.getText()).getTime());

edited May 23, 2017 at 12:15

CommunityBot

11 silver badge

answered Dec 12, 2015 at 22:50

Yassin Hajaj

22.1k10 gold badges60 silver badges93 bronze badges

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

6 Comments

Cillín Over a year ago

You sir.. are a genius! Thank you!

Yassin Hajaj Over a year ago

@Cillin Which I was:p You're welcome :)

Cillín Over a year ago

and I don't feel this question should be marked down. It wasn't really an obvious answer for a noob..

Yassin Hajaj Over a year ago

@Cillin Indeed it was not, but that happens, nothing to worry about.

Basil Bourque Over a year ago

@Cillín No, not an obvious answer. But both elements of the question have been covered many times already on StackOverflow.

|

Heri · Accepted Answer · 2015-12-12 23:02:13Z

1

Your first try probably threw the exception you mentioned because of the wrong format as Josh pointed out. After correcting this the next problem occurs: A java.sql.Date is NOT a java.util.Date. So you cannot just typecast the outcome of the df.parse, which is a java.util.Date. And third: If you provide the pattern to the SimpleDateFormat you can omit the locale. Following code runs without errors:

    String input = "1994-09-09";
    SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");
    Date date = df.parse(input);
    System.out.println( date);
    java.sql.Date sqlDate = new java.sql.Date( date.getTime() );
    System.out.println( sqlDate);

answered Dec 12, 2015 at 23:02

Heri

4,6381 gold badge34 silver badges56 bronze badges

Comments

Josh Chappelle · Accepted Answer · 2015-12-12 22:53:40Z

0

Change your format to yyyy-MM-dd.

I just wrote this program and it works fine. Make sure you aren't getting some other error now.

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Locale;

public class DateFormatDemo
{
    public static void main(String[] args) throws ParseException
    {
        SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd", Locale.ENGLISH);
        System.out.println(df.parse("1994-09-09"));
    }
}

edited Dec 12, 2015 at 22:53

answered Dec 12, 2015 at 22:43

Josh Chappelle

1,5882 gold badges17 silver badges37 bronze badges

7 Comments

Cillín Over a year ago

Didn't do the trick..

Josh Chappelle Over a year ago

Good deal. Please accept the answer. Just hitting the up arrow doesn't accept it as being the correct answer.

Cillín Over a year ago

I can't accept it if it didn't work. I got the error java.lang.classcastexception java.util.date cannot be cast to java.sql.date

Yassin Hajaj Over a year ago

@JoshChappelle It did NOT do the trick :)

TNT Over a year ago

@Cillín Then use new java.sql.Date(df.parse(...).getTime());

|

Collectives™ on Stack Overflow

java.text.parseException: unparseable date 1994-09-09 [duplicate]

3 Answers 3

Solution

6 Comments

Comments

7 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Solution

6 Comments

Comments

7 Comments

Linked

Related