mysql - Sql timestamp to Java date?

Question

I have a database which is going to have UMT timestamps in standard sql format. How can I pull that data and set a java date object with it?

As far as I know mysql is yyyy-mm-dd hh:mm:ss As for java, the date / time stuff has always eluded me.

If anyone knows of a good library for this I am open to suggestions.

Answer 1

Why don't directly read it as Date

Date date = resultSet.getTimestamp("date_field");

Timestamp timestamp = resultSet.getTimestamp("date_time_field");

See

• ResultSet.getTimeStamp()