Java date to sql date

Question

How can I store a specific date from java to my database? (Not only the date today, but also some dates that the user wants to specifiy)

try {
        SimpleDateFormat dateFormat = new SimpleDateFormat("MM/dd/yyyy");       
        Date date = dateFormat.parse(tf.getText());
        String d = dateFormat.format(date); 

        String str = "insert into tableName(tDate) values (?)";
                con = mysqlConnection.dbConnector();
                prs = con.prepareStatement(str);
                prs.setDate(1, // dont know what to put here);

                int rsUpdate = prs.executeUpdate();
                con.close();
                prs.close();
    } catch(ParseException exx) {
                System.err.println(exx);

Use a second table, which is keyed via a foreign key, to the first — MadProgrammer, Feb 03 '15 at 06:13
Have a look at this [SO Post](http://stackoverflow.com/questions/6874146/jdbc-prepared-statement-setdate-doesnt-save-the-time-just-the-date-h) — Sivakumar, Feb 03 '15 at 06:17
@MadProgrammer Save the 'date' as String first on the other table? — meatno, Feb 03 '15 at 06:22
Save the date as `java.sql.Date`...(I also assume you mean you want to store a variable list of dates) — MadProgrammer, Feb 03 '15 at 06:24
possible duplicate of [Java Date - Insert into database](http://stackoverflow.com/questions/1081234/java-date-insert-into-database) — Basil Bourque, Feb 04 '15 at 20:55

score 1 · Accepted Answer · answered Feb 03 '15 at 06:21

1

Use

prs.setDate( 1, new java.sql.Date( date.getTime() ) );

The types java.sql.Date and java.sql.Timestamp are suppoed to be used to set date and timestamp fields, respectively. Read their documentation for the differences between them and between them and java.util.Date.

You usually get a java date (java.util.Date) from the user. You convert it to milliseconds since the epoch using getTime(), and then convert back to a java.sql.Date or java.sql.Timestamp as I have shown.

answered Feb 03 '15 at 06:21

RealSkeptic

33,993
7
53
79

It inserts a whole bunch of 000's – meatno Feb 03 '15 at 06:42
@meantro Then you should put in your original question: (a) the definition of the table, and (b) the result of `System.out.println(date)` just before you do the `setDate()` so that we know it contains valid data. – RealSkeptic Feb 03 '15 at 08:05

score 0 · Answer 2 · answered Feb 03 '15 at 06:22

use this it can help

  static  java.sql.Timestamp getSqlDate(Date date) {    
        java.util.Date javaDate = date;
        long javaTime = javaDate.getTime();
        java.sql.Timestamp sqlTimestamp = new java.sql.Timestamp(javaTime);
        return sqlTimestamp;
 }

Java date to sql date

2 Answers2

Linked

Related