How to cast java.util.date to java.sql.date? [duplicate]

Question

    Date date = new Date();
    DateFormat dt = new SimpleDateFormat("yyyy-MM-dd");
     try {
         date = dt.parse("2014-03-14");
     } catch (ParseException parseException) {
     }
    orderBean.setDate((java.sql.Date) date);

when I try to cast util.date to sql.date using above code an error occurs as below. I am using mysql data base to store a data. can anyone help me?

Mar 14, 2014 11:16:44 AM gui.salespot jButton1ActionPerformed
SEVERE: null
java.lang.ClassCastException: java.util.Date cannot be cast to java.sql.Date

FYI, the terribly troublesome old date-time classes such as java.util.Date, java.sql.Date, and java.text.SimpleDateFormat are now legacy, supplanted by the java.time classes built into Java 8 and later. See Tutorial by Oracle. — Basil Bourque
– Basil Bourque, Commented Dec 31, 2018 at 2:36

Suresh Atta · Accepted Answer · 2014-03-14 06:04:29Z

5

No. You cannot cast different type of Objects like that.

instead you can get the time which is long and use it.

java.sql.Date sDate = new java.sql.Date(date.getTime());

answered Mar 14, 2014 at 6:04

Suresh Atta

122k38 gold badges206 silver badges315 bronze badges

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

Comments

SpringLearner · Accepted Answer · 2014-03-14 06:04:36Z

2

try this way

Date date = new Date();
java.sql.Date d=new java.sql.Date(date.getTime());

answered Mar 14, 2014 at 6:04

SpringLearner

13.9k20 gold badges82 silver badges117 bronze badges

Comments

MadProgrammer · Accepted Answer · 2014-03-14 06:04:51Z

1

java.sql.Date extends from java.util.Date, so you can case java.sql.Date to java.util.Date but not the other way round.

Try using...

orderBean.setDate(new java.sql.Date(date.getTime()));

Instead...

answered Mar 14, 2014 at 6:04

MadProgrammer

348k22 gold badges243 silver badges379 bronze badges

1 Comment

SpringLearner Over a year ago

almost all the answers are upvoted except yours though your answer has good explanations,+1 from my side

Subhrajyoti Majumder · Accepted Answer · 2014-03-14 06:05:03Z

1

java.util.Date is superclass of java.sql.Date you can not type cast it by this way.

try with - java.sql.Date#Date(long)

Snippet -

java.sql.Date sqlDate = new java.sql.Date(date.getTime())

answered Mar 14, 2014 at 6:05

Subhrajyoti Majumder

41.3k13 gold badges84 silver badges103 bronze badges

Comments

jmail · Accepted Answer · 2014-03-14 06:06:18Z

0

look like simple....

public class MainClass {

  public static void main(String[] args) {
    java.util.Date utilDate = new java.util.Date();
    java.sql.Date sqlDate = new java.sql.Date(utilDate.getTime());
    System.out.println("utilDate:" + utilDate);
    System.out.println("sqlDate:" + sqlDate);

  }
}

explains it. The link is click

answered Mar 14, 2014 at 6:06

jmail

6,1503 gold badges23 silver badges35 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 11:49:46Z

0

Use this answer to convert date.

java.util.Calendar cal = Calendar.getInstance();
java.util.Date utilDate = new java.util.Date(); // your util date
cal.setTime(utilDate);
cal.set(Calendar.HOUR_OF_DAY, 0);
cal.set(Calendar.MINUTE, 0);
cal.set(Calendar.SECOND, 0);
cal.set(Calendar.MILLISECOND, 0);    
java.sql.Date sqlDate = new java.sql.Date(cal.getTime().getTime()); // your sql date
System.out.println("utilDate:" + utilDate);
System.out.println("sqlDate:" + sqlDate);

For your concern copy my code.

    Date date = new Date();
    DateFormat dt = new SimpleDateFormat("yyyy-MM-dd");
     try {
         date = dt.parse("2014-03-14");
     } catch (ParseException parseException) {
     }
      orderBean.setDate(new java.sql.Date(date.getTime()));

Check this reference.. Thanks..

edited May 23, 2017 at 11:49

CommunityBot

11 silver badge

answered Mar 14, 2014 at 6:09

Java Man

1,8703 gold badges21 silver badges44 bronze badges

Collectives™ on Stack Overflow

How to cast java.util.date to java.sql.date? [duplicate]

6 Answers 6

Comments

Comments

1 Comment

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

1 Comment

Comments

Comments

Comments

Linked

Related