Get the current date and save it in the database

advertisements

How do I get the current date with the format of yyyy-MM-dd and save it in database with Date value? I have this code but it does not work...

Java:

Calendar cal = Calendar.getInstance();
java.util.Date d = new java.util.Date();
d.setMonth(cal.get(Calendar.MONTH));
d.setDate(cal.get(Calendar.DATE)-1900);
d.setYear(cal.get(Calendar.YEAR));

Here is my PreparedStatement:

pstmt.setDate(6, (Date)d);


You have to use java.sql.Date instance to set to database column.

Convert the java.util.Date instance to java.sql.Date.

You can also use Calander instance to convert.

Change:

pstmt.setDate( 6, (Date)d );

To:

pstmt.setDate( 6, new java.sql.Date( d.getTime() ) );

OR To:

pstmt.setDate( 6, new java.sql.Date( cal.getTimeInMillis() ) );