Getting current Date and saving it in database

Question

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);

http://stackoverflow.com/questions/3469507/how-can-i-change-the-date-format-in-java — Divya, Mar 28 '14 at 12:43

score 4 · Accepted Answer · answered Mar 28 '14 at 12:43

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() ) );

score 1 · Answer 2 · answered Mar 28 '14 at 13:01

1

DateFormat dateFormat = new SimpleDateFormat("dd-MM-yyyy");
Date date = new Date();
System.out.println("Current Date : "+dateFormat.format(date));

using insert query you can save this date object to database.

answered Mar 28 '14 at 13:01

Sathesh

378
1
4
13

score 0 · Answer 3 · answered Mar 28 '14 at 12:53

    long timeInMillis = System.currentTimeMillis();
    Calendar cal1 = Calendar.getInstance();
    cal1.setTimeInMillis(timeInMillis);
    SimpleDateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy     hh:mm:ss a");
    String date=dateFormat.format(cal1.getTime());
    return date;

Getting current Date and saving it in database

3 Answers3