How do I pass a Date as SQL parameter in Java without losing the time part?

Question

For example, I have this String: 06/10/2013 18:29:09. I want to convert this string and put it in a SQL database (as Date).

How can I convert this to an sql date, so that it could be inserted into a database? I want the hours minutes and seconds to remain as well.

I tried the following:

SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy HH:mm:ss");
Date javaDate = sdf.parse("06/10/2013 18:29:09");
java.sql.Date date = new java.sql.Date(javaDate.getTime());

I'm not sure i get totally what you mean but is it something like you want to insert the java.util.Date into an SQL varchar in just that format? — Zuko, Jun 02 '14 at 14:49
You probably are looking for [java.sql.Timestamp](http://download.oracle.com/javase/8/docs/api/java/sql/Timestamp.html) since java.sql.Date or java.sql.Time doesn't support format you described. — Pshemo, Jun 02 '14 at 14:49
[`SimpleDateFormat`](http://docs.oracle.com/javase/8/docs/api/java/text/SimpleDateFormat.html). — Luiggi Mendoza, Jun 02 '14 at 14:49
Why downvoting? I did a lot of research before asking this question. — n00b1990, Jun 02 '14 at 14:50
Because converting a `String` into a `Date` is no rocket science in Java and is widely covered in tutorials, blog entries and more places in the net. — Luiggi Mendoza, Jun 02 '14 at 14:51
"a lot of research"? And you didnt try this? https://www.google.com/search?q=convert%20string%20to%20sql%20date — f1sh, Jun 02 '14 at 14:52
I already tried as I posted above, but when I call the toString of the sqlDate, I get 06-10-2013, or something in that kind — n00b1990, Jun 02 '14 at 14:54
Now that you have updated the code, it is easier to understand **your real problem**. — Luiggi Mendoza, Jun 02 '14 at 14:54
Thanks for the help guys, I appreciate it. I'll take a look at the other question — n00b1990, Jun 02 '14 at 15:06
Thank you, I'll try to ask my questions a little clearer from now on — n00b1990, Jun 02 '14 at 15:10

score 7 · Accepted Answer · edited May 23 '17 at 10:29

7

The problem is here:

java.sql.Date date = new java.sql.Date(javaDate.getTime());

java.sql.Date stores the date part of your timestamp. If you want/need to handle both date and time, use java.sql.Timestamp instead:

java.sql.Timestamp date = new java.sql.Timestamp (javaDate.getTime());

More info:

Date vs TimeStamp vs calendar?

edited May 23 '17 at 10:29

Community

1
1

answered Jun 02 '14 at 14:53

Luiggi Mendoza

85,076
16
154
332

First correct answer! – gexicide Jun 02 '14 at 15:03

score 1 · Answer 2 · answered Jun 02 '14 at 14:52

1

You will use a SimpleDateFormat object to parse the string to java.util.date and then use the getTime() method to instantiate a java.sql.Date.

    String input = "06/10/2013 18:29:09";
    SimpleDateFormat sdf = new SimpleDateFormat("MM/dd/yyyy hh:mm:ss");
    java.util.Date dt = sdf.parse(input);
    java.sql.Date dtSql = new java.sql.Date(dt.getTime());

answered Jun 02 '14 at 14:52

NRJ

1,064
3
15
32

Check the code from OP. He's doing this exactly and it is failing. – Luiggi Mendoza Jun 02 '14 at 15:02
Yup - Agree with other comments. He needs to use Timestamp. – NRJ Jun 02 '14 at 15:03

score 0 · Answer 3 · answered Jun 02 '14 at 14:50

0

If you are working with String type for date input and then you want to save that in a database like MySQL, you should use an appropriate Date Format for it. There's a class called "SimpleDateFormat" which you can use for that purpose. You can find a sample in the following link, also a brief explanation on how it works. Hope it helps.

Example: http://www.java2s.com/Tutorial/Java/0040__Data-Type/SimpleDateFormat.htm

Best Regards.

answered Jun 02 '14 at 14:50

Marcelo Tataje

3,849
1
26
51

Instead of linking to a tutorial, it would be better to provide an example. Usage of `SimpleDateFormat` is no rocket science. – Luiggi Mendoza Jun 02 '14 at 14:50

score 0 · Answer 4 · answered Jun 02 '14 at 14:56

Here's a simple demo. In a Database table like this.

You can insert into it like this.

 //the SQL statement for creating the database table
 create table user(id, integer primary key, username varchar(100), date_created varchar(100));

 //the java code to insert into the table created above.
 try{
 String date = new SimpleDateFormat("dd/MM/YYYY HH:mm:ss").format(new Date());
 String sql = "insert into user(username, date_created) values('olupotd', '"+date+"')";
 int done = statement.executeUpdate(sql);
 if(done > 0)
    //inserted
 else
   //not inserted.
 }catch(java.sql.SQLException e){}

Hope that helps

How do I pass a Date as SQL parameter in Java without losing the time part?

4 Answers4