Converting java date into sql date in jdbc

Question

  for (final Object[] obj : leaveObjects) {
             for (int i = 0; i < obj.length; i++){
     try {

            jdbcTemplate.update(new PreparedStatementCreator() {
                public PreparedStatement createPreparedStatement(
                        Connection connection) throws SQLException {
                    PreparedStatement ps = connection.prepareStatement(sql,
                            new String[] { "pk_CompOff_compOffId" });
                    ps.setInt(1,  (Integer)obj[0]);
                    ps.setInt(2,  (Integer)obj[1]);
                    ps.setInt(3,  (Integer)obj[2]);
                    ps.setInt(4, (Integer) obj[3]  );
                    try {
                        ps.setDate(5, new java.sql.Date(formatter.parse(obj[4].toString()).getTime()));
                    } catch (ParseException e) {
                        // TODO Auto-generated catch block
                        e.printStackTrace();
                    }

I am trying to save this date from java to the database using spring jdbc template using the above code but getting this exception:

java.text.ParseException: Unparseable date: "Sun Feb 15 00:00:00 PST 2015" . i am using this formatter

 SimpleDateFormat formatter = new SimpleDateFormat("EEEE, MMM dd, yyyy HH:mm:ss a");

How I can resolve that?

@saurabh try this for your fomatter: `EEEE MMM dd HH:mm:ss z yyyy` — nafas, Dec 09 '15 at 11:17
Please search StackOverflow. You would have found hundreds of examples of working code to compare to your own. — Basil Bourque, Dec 10 '15 at 00:35

score 0 · Answer 1 · answered Dec 09 '15 at 11:20

0

change :

SimpleDateFormat formatter = new SimpleDateFormat("EEEE, MMM dd, yyyy HH:mm:ss a");

to:

SimpleDateFormat formatter = new SimpleDateFormat("EEEE MMM dd HH:mm:ss z yyyy");

Note:

a is replaced by z
commas are removed
some fields have chnaged places

a used for AM/PM where as z used for Time zone (e.g. PST)

For more reference, check this documentation:

http://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html

answered Dec 09 '15 at 11:20

nafas

5,283
3
29
57

I wonder if it was @chokdee who downvoted this answer. – Tom Dec 09 '15 at 11:51
@Tom beats me, I think answer is accurate with enough explaination... – nafas Dec 09 '15 at 12:06

score 0 · Answer 2 · answered Dec 09 '15 at 11:37

0

You have to use the Locale too, otherwise it will not run in every locale.

Try this

SimpleDateFormat formatter = new SimpleDateFormat("EEE MMM dd HH:mm:ss z yyyy", Locale.US);

answered Dec 09 '15 at 11:37

chokdee

446
4
13

Converting java date into sql date in jdbc

2 Answers2