java date to sql date type conversion

Question

I am trying to convert a java date object to sql date object. I tried to implement something on my own and came up with the following:

try {
    rs.updateDate("", (java.sql.Date) new SimpleDateFormat("dd-MM-yyyy").parse(jTextFieldDate.getText()));
} catch (ParseException ex) {
    Logger.getLogger(helpdesk.class.getName()).log(Level.SEVERE, null, ex);
}

Here rs is a Result Set object and jTextFieldDate as the name suggests is a java text field object. Is this implementation correct. What are the possible problems i may encounter by using this code.....

Casting is not a conversion - it only works if the target type and the actual type are related in terms of class hierarchies and implemented interfaces, i.e. if the actual type already is the target type. You need a mapping, not a cast. — hiergiltdiestfu
– hiergiltdiestfu, Commented Jun 5, 2014 at 7:11

Fortega · Accepted Answer · 2014-06-05 07:10:31Z

2

This will not work. You cannot cast a java.util.Date (returned by the parse method of SimpleDateFormat) to java.sql.Date. To convert the java.util.Date to java.sql.Date, you can do the following:

try {
    java.util.Date utilDate = new SimpleDateFormat("dd-MM-yyyy").parse(jTextFieldDate.getText());
    java.sql.Date sqlDate = new java.sql.Date(utilDate.getTime());
    rs.updateDate("", sqlDate);
} catch (ParseException ex) {
    Logger.getLogger(helpdesk.class.getName()).log(Level.SEVERE, null, ex);
}

answered Jun 5, 2014 at 7:10

Fortega

19.7k15 gold badges78 silver badges115 bronze badges

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

Comments

Fortega · Accepted Answer · 2014-06-05 07:40:51Z

2

The code

 new SimpleDateFormat("dd-MM-yyyy").parse(jTextFieldDate.getText()))

returns a java.util.Date not a java.sql.Date

You can construct a java.sql.Date using a long tm which you can from java.util.Date.getTime ()

edited Jun 5, 2014 at 7:40

Fortega

19.7k15 gold badges78 silver badges115 bronze badges

answered Jun 5, 2014 at 7:13

Scary Wombat

44.9k6 gold badges38 silver badges67 bronze badges

Collectives™ on Stack Overflow

java date to sql date type conversion

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related