Unparseable date: ""

Question

Need help with parsing date(dateInString). I am new to parsing of date. Thanks for help

String dateInString = Commons.getString(row.getCell(1));
Date date = new Date();
if (!dateInString.equals("null") || !dateInString.equals("")) {
    DateFormat formatter = new SimpleDateFormat("dd.MM.yy");
    date = formatter.parse(dateInString);
}
java.sql.Date sDate = convertUtilToSql(date);

private java.sql.Date convertUtilToSql(Date date) {
    java.sql.Date sDate = new java.sql.Date(date.getTime());
    return sDate;
}

That messages says the input to `parse` (i.e. `dateInString`) was an empty string. Thus the previous line that defines `dateInString` is not returning what you expect. — Jim Garrison, May 20 '16 at 05:46
@JimGarrison I tried changing the code, but getting the same error — spt, May 20 '16 at 05:51
Your answer is probably [here](http://stackoverflow.com/questions/513832/how-do-i-compare-strings-in-java). Basically, `dateInString != ""` is just _wrong_. — ajb, May 20 '16 at 06:01
Well, at least you fixed one problem. But we can't help you without knowing what your input is. — ajb, May 20 '16 at 06:07
@Flynn1179 But it is inserting into database but getting exception at the end — spt, May 20 '16 at 06:16

score 0 · Answer 1 · answered May 20 '16 at 06:44

0

It seems that your if statement is not correct. It enters the parsing if the string context is not null or string is not empty. That looks wrong to me. The parsing should only happen if the dateString is not null AND doesn contain the value null AND is not an empty string.

So I guess that the part

if (!dateInString.equals("null") || !dateInString.equals("")) {
    DateFormat formatter = new SimpleDateFormat("dd.MM.yy");
    date = formatter.parse(dateInString);
}

has to be changed into something like

if (dateString!= null && !dateInString.equals("null") && !dateInString.trim().isEmpty()) {
    DateFormat formatter = new SimpleDateFormat("dd.MM.yy");
    date = formatter.parse(dateInString.trim());
}

answered May 20 '16 at 06:44

uniknow

938
6
5

null values are also inserting into database after modifying it – spt May 20 '16 at 07:27
What do you mean exactly by that? The original implementation doesn't seem to do anything with null as dateString. – uniknow May 20 '16 at 07:38
null values are getting inserted, when using if statement – spt May 20 '16 at 10:50
Don't see how thy would be inserted. In your original solution date is set to current date and later converted to sql date which is probably inserted in db. Anyway, a DateString with value null would could nullpointer exception in `date = formatter.parse(dateInString.trim());` so that's why is excluded null – uniknow May 20 '16 at 12:49

Unparseable date: ""

1 Answers1