File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Retreiving the current data from the database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Retreiving the current data from the database" Watch "Retreiving the current data from the database" New topic
Author

Retreiving the current data from the database

Hanna Habashy
Ranch Hand

Joined: Aug 20, 2003
Posts: 532
I am trying to get the date from the database. I can read it fin, but the hour, minutes, and sec values are missing.
Here is a segment of my code:


The value in sqlDate returned is 2009-09-03, however the value returned from the database console is 2009-09-03 12:16:13.747

How can I get the full date?
I tried use Date.getTime(), cast it to java.util.Date, not it not working.

Your help is appreciated.


SCJD 1.4<br />SCJP 1.4<br />-----------------------------------<br />"With regard to excellence, it is not enough to know, but we must try to have and use it.<br />" Aristotle
Rene Larsen
Ranch Hand

Joined: Oct 12, 2001
Posts: 1179

Have you tried with rs.getTimestamp(1) ??


Regards, Rene Larsen
Dropbox Invite
Hanna Habashy
Ranch Hand

Joined: Aug 20, 2003
Posts: 532
Rene Larsen wrote:Have you tried with rs.getTimestamp(1) ??



Thank you very much, this solved it.
 
wood burning stoves
 
subject: Retreiving the current data from the database
 
Similar Threads
Save date to the database
date problem
convert a String into Date with SimpleDateFormat
Please help...
util.Date to sql.Date