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.

Jigar Joshi · Accepted Answer · 2012-06-15 18:18:24Z

4

Why don't directly read it as Date

Date date = resultSet.getTimestamp("date_field"); Timestamp timestamp = resultSet.getTimestamp("date_time_field");

See

ResultSet.getTimeStamp()

answered Jun 15, 2012 at 18:18

Jigar Joshi

241k42 gold badges409 silver badges446 bronze badges

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

1 Comment

Affe Over a year ago

That is NOT safe for use in comparison with other instances of java.util.Date that are not actually a java.sql.Timestamp underneath. A new java.util.Date should be made from the long value of the java.sql.Timestamp

Istvan Devai · Accepted Answer · 2012-06-15 18:32:23Z

A Timestamp is a subclass of a Date, which means it is usable everywhere where a Date is. The only difference is, Timestamp is more precise (due to the SQL specification) than Date is.

Just use:

Timestamp t = resultSet.getTimestamp("columnname"); Date d = t;

That having said, there are some benefits of converting the JDBC returned timestamp into a proper Date value, omitting nanoseconds. When you compare a Timestamp and a Date in some remote part of your app, the Timestamp and the Date won't be equal, even though they seem to be "rougly" the same time value. So if this could cause problem, create a new Date instance using only the .getTime() value returned by Timestamp)

More on this in my blog: Timestamp and Date equality when using Hibernate

(even though the blog entry is about Hibernate, it applies to your case as well)

Collectives™ on Stack Overflow

Sql timestamp to Java date?

2 Answers 2

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Linked

Related