How do I extract a Postgres timestamp field using java?

My data is in format:

2010-12-01 09:59:00.423

getDate in Java only returns the date portion. 开发者_开发技巧Is there a way to also extract the time?

---

The SQL DATE type indeed only contains the date portion, not the time. But your column is apparently of TIMESTAMP type, so to get the full timestamp, use ResultSet#getTimestamp() instead.

Date date = resultSet.getTimestamp("columnname");
// ...

It returns java.sql.Timestamp which is a subclass of java.util.Date, so the upcast is safe.