CODEWITHSUNDEEP
javadateuser-interfacedatetimepicker
Basheer Kharoti
Basheer Kharoti

Reputation: 4302

How to get date datatype from sql database to java?

How to get the date datattype from sql database to java??? so far I have use this code but failed to fetch the date. 

import java.sql.*;//this is my import file
     String search="select * from tblflight";//select all data from my table
     ResultSet rs=stmt.executeQuery(search);//puting result in temporary var
     while(rs.next())
{
   Date d_time=rs.getDate("date_time");//getting result
   combo_box.addItem(d_time);//n showing error here while putting the date var here
}

Upvotes: 0

Views: 18035

Answers (2)

Sarjit Delivala
Sarjit Delivala

Reputation: 567

If combo box is not allowing object to inserted, while adding it to the combo_box use d_time.toString() method.

Upvotes: 0

Naveen Ramawat
Naveen Ramawat

Reputation: 1445

You have two options.
1 - Take sql date object and construct utils date using the getTime method of sql date
or
2 - call getTimeStamp instead of getDate , It will return object of sql timeStamp class that is actually child class of java.util.Date

1 -  Date d1 = new Date(rs.getDate("date_time").getTime());
2 -  Date d2 = rs.getTimestamp("date_time");

Upvotes: 1

Related Questions