Java: java.util.date cannot be cast to java.sql.Time

Question

I have time converted from millis and now i would like to make an SQL Insert with that time value. I tried this but it is not working:

        String INSERT_RECORD ="INSERT INTO PRAVIDLA (CAS,DEN,MIESTNOST,STAV) values(?,?,?,?)";
        PreparedStatement pstmt = con.prepareStatement(INSERT_RECORD);

        Calendar calendar1 = Calendar.getInstance(TimeZone.getTimeZone("UTC"));       
        calendar1.setTimeInMillis(milli);
        Time Cas2 = (Time) calendar1.getTime();

        pstmt.setTime(1, Cas2);
        pstmt.setInt(2, DEN);
        pstmt.setString(3, MIESTNOST);
        pstmt.setString(4, STAV);
        pstmt.executeUpdate();

Any suggestions please?

You can't just cast different types like that. Use the fields of `Date` to create a new `Time`. — Sotirios Delimanolis, Mar 04 '13 at 17:18
@SotiriosDelimanolis have you worked with `java.sql.Time` before? Because there's no `java.util.Date` argument to pass to its constructor. — Luiggi Mendoza, Mar 04 '13 at 17:19
Dup of http://stackoverflow.com/questions/5950806/merge-java-util-date-with-java-sql-time — mazaneicha, Mar 04 '13 at 17:20
@LuiggiMendoza Can't you use the constructor `Time(long time)` with `Date#getTime()`? — Sotirios Delimanolis, Mar 04 '13 at 17:20

score 9 · Answer 1 · answered Mar 04 '13 at 17:20

9

java.sql.Time extends java.util.Date, so you cannot simply cast it.

You can try something like this:

Time time = new Time(date.getTime());

answered Mar 04 '13 at 17:20

João Vitor Verona Biazibetti

2,223
3
18
30

@LuiggiMendoza Fixed, now using another constructor. – João Vitor Verona Biazibetti Mar 04 '13 at 17:21

score 5 · Accepted Answer · answered Mar 04 '13 at 17:24

5

The following is what I did when I had a similar problem.

java.util.Date utilDate = new java.util.Date("mm/dd/yyyy");
java.sql.Date sqlDate = new java.sql.Date(utilDate.getTime());

Substitute a real date for "mm/dd/yyyy"

answered Mar 04 '13 at 17:24

Susie

5,038
10
53
74

score 0 · Answer 3 · answered Mar 04 '13 at 17:20

0

calendar1.getTime() returns a Date object, and Time is a sub-class of Date, so a Date cannot be cast into a Time. You can try this instead:

Time Cas2 = new Time(calendar1.getTimeInMillis());

answered Mar 04 '13 at 17:20

Hari Menon

33,649
14
85
108

score 0 · Answer 4 · edited Apr 12 '14 at 19:04

0

public class Time extends java.util.Date

It is not possible to cast Date to Time.

You can use this instead:

Time time = new Time(date.getTime())

edited Apr 12 '14 at 19:04

Daniel

1,861
1
15
23

answered Mar 04 '13 at 17:20

score 0 · Answer 5 · answered Mar 04 '13 at 17:23

0

You can try this. I've not tested the code.

Time time = new Time(calendar.get(Calendar.MILLISECOND) 
            + calendar.get(Calendar.ZONE_OFFSET));

You might have to subtract the zone offset.

answered Mar 04 '13 at 17:23

Gilbert Le Blanc

50,182
6
67
111

Java: java.util.date cannot be cast to java.sql.Time

5 Answers5