How do I extract a Postgres timestamp field using java?

Question

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?

BalusC · Accepted Answer · 2011-05-31 02:37:48Z

25

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.

answered May 31, 2011 at 2:37

BalusC

1.1m377 gold badges3.7k silver badges3.6k bronze badges

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

Collectives™ on Stack Overflow

How do I extract a Postgres timestamp field using java?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related