How to insert date in MySQL using Java [duplicate]

Question

I have a variable of type Date. I get this date by using a function that return type Date. So, I defined two variables as:

Date expDate=null, startDate=null;

Then, I called the functions:

expDate=c.getNotAfter();
startDate= c.getNotBefore();

Then, inserted into the database using:

prepStmt.setDate(1,(java.sql.Date) startDate);
prepStmt.setDate(2, (java.sql.Date) expDate);

After running the program, I get this error:

java.util.Date cannot be cast to java.sql.Date

The columns in the database are defined as DATETIME type. How can I resolve the issue?

Peter Mortensen · Accepted Answer · 2013-04-06 13:48:55Z

3

Do like this:

  prepStmt.setDate(1,new java.sql.Date(startDate.getTime()));

java.sql.Date is a thin wrapper around a millisecond value that allows JDBC to identify this as an SQL DATE value. A milliseconds value represents the number of milliseconds that have passed since January 1, 1970 00:00:00.000 GMT.

java.util.Date classes getTime() returns the time in miliseconds. You can use this to create a new object of java.sql.Date class.

If you want time along with date, then use Timestamp:

prepStmt.setTimestamp(1,new java.sql.Timestamp(startDate.getTime()));

edited Apr 6, 2013 at 13:48

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Nov 22, 2012 at 4:29

Bhavik Shah

5,1933 gold badges26 silver badges40 bronze badges

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

3 Comments

user1810868 Over a year ago

The problem here is that the date s inserted correctly, but the time inserted in the DB as: 00:00:00.

Bhavik Shah Over a year ago

the you have to use setTimestamp() as java.sql.Date discards the time part

viveksinghggits Over a year ago

the values that is being stored in the database is in format 10-May-16 12:00:00 AM, I want it to be stored in the format 10-May-16 what can be done.?

Peter Mortensen · Accepted Answer · 2013-04-06 13:50:07Z

3

Use it like this:

prepStmt.setDate(1,new java.sql.Date(startDate.getTime()));

This is because setDate() method of PreparedStatement requires an object of java.sql.Date type as second argument and not java.util.Date.

So first get the time in milliseconds from your java.util.Date object and then use that in the constructor of java.sql.Date.

edited Apr 6, 2013 at 13:50

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Nov 22, 2012 at 4:26

Abubakkar

15.7k8 gold badges58 silver badges84 bronze badges

Comments

Sergiu Dumitriu · Accepted Answer · 2013-03-16 13:10:09Z

1

prepStmt.setDate(1, (java.sql.Date) startDate);   
prepStmt.setDate(2, (java.sql.Date) expDate);  
prepStmt.setDate(1, new java.sql.Date(startDate.getTime()));

edited Mar 16, 2013 at 13:10

Sergiu Dumitriu

11.7k3 gold badges43 silver badges63 bronze badges

answered Mar 16, 2013 at 12:48

Radhe

111 bronze badge

Collectives™ on Stack Overflow

How to insert date in MySQL using Java [duplicate]

3 Answers 3

3 Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Linked

Related