CODEWITHSUNDEEP
javajdbc
aherlambang
aherlambang

Reputation: 14418

String to Date in a PreparedStatement

I am trying to use setDate() in a PreparedStatement, however the date that I have is in the format of 2008-07-31. The code is:

 pstmt.setDate(f++, (Date) DateFormat.getDateInstance(DateFormat.DEFAULT).parse(value.substring(0, 10)));

However, it gives me the error:

Exception in thread "main" java.text.ParseException: Unparseable date: "2008-07-31"

Why is this?

Upvotes: 0

Views: 11415

Answers (6)

bluish
bluish

Reputation: 27320

I'd use

pstmt.setDate(f++, 
              new java.sql.Date(
                  new SimpleDateFormat("yyyy-MM-dd")
                      .parse(value.substring(0, 10))
                      .getTime()
                  )
             );

Upvotes: 0

developer
developer

Reputation: 9478

First convert String to Date and then set that to PreparedStatement. Check with below code.

SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-mm-dd"); 
Date convertedDate = dateFormat.parse(dateString);

Upvotes: 0

LiuYan 刘研
LiuYan 刘研

Reputation: 1624

You need make sure the default DateFormat is in yyyy-MM-dd format (usually it's a config in OS), or you can use SimpleDateFormat or java.sql.Date to parse date string.

java.util.Date d;
SimpleDateFormat sdf = new SimpleDateFormat ("yyyy-MM-dd");
d = sdf.parse ("2008-07-31");

// or
d = java.sql.Date.valueOf ("2008-07-31");

or, you could just set parameter as String, if the underlying database driver support the VARCHAR/CHAR to DATE conversion.

Upvotes: 3

ajm
ajm

Reputation: 13213

I think there is mismatch in the format of the date that you are providing as input and the format in which you have specified while formatting which is default in your case. 

SimpleDateFormat parser = new SimpleDateFormay("yyyy-MM-dd");

Try using the same format for both the dates.

Upvotes: 0

Krishna
Krishna

Reputation: 1871

DateFormat.DEFAULT points to MEDIUM format and MEDIUM format looks like Jan 12, 1952. So, you may have create a SimpleDateFormat object with the format you are using.

Upvotes: 1

Jon Skeet
Jon Skeet

Reputation: 1500903

If you have a very specific date, don't ask Java to use a default date format - set it yourself.

For example:

DateFormat parser = new SimpleDateFormat("yyyy-MM-dd");
Date date = parser.parse(value.substring(0, 10));

You should also potentially set the time zone of the parser... my guess is that UTC is the most appropriate time zone here.

Note that this has nothing to do with prepared statements as such - it's just date parsing.

(As an alternative to using DateFormat and SimpleDateFormat, you could use Joda Time which has a nicer API and thread-safe formatters/parsers. You can ask Joda Time to convert from its own types to Date values. Possibly overkill if you only need it for parsing here, but if you're doing anything else with dates, it's well worth looking into.)

Upvotes: 4

Related Questions