Retreiving the current data from the database

[Hanna Habashy]

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:

  
String sql = "select getDate()";
statement = connection.createStatement();
      rs = statement.executeQuery(sql);
      rs.next();
      sqlDate = (rs.getDate(1, Calendar.getInstance()));  

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.

[Rene Larsen]

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

[Hanna Habashy]

Rene Larsen wrote:Have you tried with rs.getTimestamp(1) ??

Thank you very much, this solved it.