How to covert date variable to java.sql.date

Question

I am facing difficulties while trying to insert a date variable into a database table. My variable is called:

Date date4;

The date4 variable value is read from a textbox which has a calendar picker. For inserting in a date column, I am setting the field type to date:

preparedstmt.setDate(4,date4);

However, I got the below message after submitting the form:

javax.faces.component.UpdateModelException: java.lang.IllegalArgumentException: Cannot convert 4/1/15 12:00 AM of type class java.util.Date to class java.sql.Date

Also, is there a way to insert the field in the format of date ("dd-MON-YYYY")?

This question has been asked and answered many times before on this site and elsewhere, q.v. this post for example. — Tim Biegeleisen
– Tim Biegeleisen, Commented Apr 1, 2015 at 14:07
Can I insert the format of date ("dd-MON-YYYY") in a date column? — Learner30
– Learner30, Commented Apr 1, 2015 at 14:09

M Sach · Accepted Answer · 2015-04-01 14:06:52Z

1

Convert util date to sql date

    java.sql.Date sqlDate = new java.sql.Date(date4.getTime());

edited Apr 1, 2015 at 14:06

answered Apr 1, 2015 at 14:05

M Sach

34.6k78 gold badges232 silver badges317 bronze badges

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

2 Comments

Learner30 Over a year ago

Thanks for the answer... Is there a way is there a way to insert the field in the format of date ("dd-MON-YYYY") of type date?

M Sach Over a year ago

From java side you just specify that its sql. Now its upto DB vendor, how to represent that date. You need to check it for your DB vendor

Collectives™ on Stack Overflow

How to covert date variable to java.sql.date

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related