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
– MadProgrammer, Commented Feb 3, 2015 at 6:13
@MadProgrammer Save the 'date' as String first on the other table? — meatno
– meatno, Commented Feb 3, 2015 at 6:22
Save the date as java.sql.Date...(I also assume you mean you want to store a variable list of dates) — MadProgrammer
– MadProgrammer, Commented Feb 3, 2015 at 6:24

RealSkeptic · Accepted Answer · 2015-02-03 06:21:17Z

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 3, 2015 at 6:21

RealSkeptic

34.8k7 gold badges56 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

meatno Over a year ago

It inserts a whole bunch of 000's

RealSkeptic Over a year ago

@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.

user3545242 · Accepted Answer · 2015-02-03 06:22:47Z

0

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

answered Feb 3, 2015 at 6:22

user3545242

714 bronze badges

Collectives™ on Stack Overflow

Java date to sql date

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related