How to insert java.util.Date object holding date and time into mysql database

Question

I am using following code to insert a java.util.Date object in MySQL. d1 is date object I'm getting from a function. I tried casting java.util.Date into java.sql.Date but this doesn't save the time part.

String sql = "INSERT INTO abc " +
              "VALUES" + "('Zara',?)";
pstmt = conn.prepareStatement(sql);
pstmt.setDate(1, d1);
stmt.executeUpdate(sql);

Any Idea to store Date and time of Date Object in MySQL?

Use `setTimestamp(new Timestamp(date.getTime()))` – JB Nizet Mar 17 '14 at 07:22 — JB Nizet, Mar 17 '14 at 07:22

score 5 · Accepted Answer · answered Mar 17 '14 at 07:21

5

You need to convert java.util.Date instance to java.sql.Date format. and then use it with PreparedStatement.

Change:

pstmt.setDate( 1, d1 );

to:

pstmt.setDate( 1, new java.sql.Date( d1.getTime() );

If the field is of type datetime or timestamp, you have to use

pstmt.setTimestamp( 1, new java.sql.Timestamp( d1.getTime() );

answered Mar 17 '14 at 07:21

Ravinder Reddy

23,692
6
52
82

java.sql.Date doesn't hold any time part. It's limited to year, month and day. The OP even said it in his question. – JB Nizet Mar 17 '14 at 07:24
Is there any way to store time part of java.util.Date Object? – cks Mar 17 '14 at 07:27
1

@cks The second part of this answer explains how. – Mark Rotteveel Mar 17 '14 at 07:28
When using util date object to convert into sql timestamp you will not be getting any time part. you need to add explicitly. are just change your sql to use `now()` unless it is a manual input. – Ravinder Reddy Mar 17 '14 at 07:30

How to insert java.util.Date object holding date and time into mysql database

1 Answers1