Cannot cast java.util.date to java.sql.date [duplicate]

Question

I have the following code snippet where i get continous error for casting java.util.date to java.sql.date.

        SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy");

        storedProcedureCall.setLong(1, 12345);
        storedProcedureCall.setDate(2, (java.sql.Date) sdf.parse("09/02/2017"));
        storedProcedureCall.setDate(3, (java.sql.Date) sdf.parse("10/02/2017"));

What am i doing wrong here. I have imported the java.util.Date package as well.

Any reason why you are using the long outdated classes java.util.Date and java.sql.Date? I recommend the modern Java date and time API known as JSR-310 or java.time. You can pass a LocalDate or other modern object to PreparedStatement.setObject(), also when using the CallableStatement subinterface, of course. — Anonymous
– Anonymous, Commented Oct 23, 2017 at 9:28
java.sql.Date extends (is a subclass of) java.util.Date. The parse() method returns a java.util.Date, and you can't cast it to a subclass: stackoverflow.com/questions/30414859/… — user7605325
– user7605325, Commented Oct 23, 2017 at 10:35

Zabuzard · Accepted Answer · 2017-10-23 08:53:18Z

1

The class java.util.Date is totally different to java.sql.Date. Thus it can not be cast to.

You probably meant to use java.util.Date. Check your signature of storedProcedureCall#setDate, it probably accidentally imported java.sql.Date instead of java.util.Date.

Note that nowadays the Date class should not be used anymore. Instead use the new modern API located inside the package java.time. Like this:

DateTimeFormatter formatter = DateTimeFormatter.ofPattern("dd/MM/yyyy");
LocalDateTime dateTime = LocalDateTime.parse(dateAsString, formatter);

edited Oct 23, 2017 at 8:53

answered Oct 23, 2017 at 8:45

Zabuzard

26.3k8 gold badges61 silver badges92 bronze badges

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

1 Comment

Basil Bourque Over a year ago

Incorrect, java.util.Date and java.sql.Date are not “totally different”. Unfortunately, just the opposite. java.sql.Date inherits from java.util.Date. So while java.sql.Date pretends to hold only a date without a time-of-day and without a time zone, it does indeed hold both a time-of-day and a time zone. Actually two time zones — while the date-time tracked as a count from UTC (and therefore represents a moment in UTC), there actually is a time zone assigned deep in the source code without any getter/setter. Total train wreck of bad design. Use java.time instead.

Collectives™ on Stack Overflow

Cannot cast java.util.date to java.sql.date [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related