MySQL timestamp to Java date conversion

Question

How can I convert time in unix timestamp to normal time?

Answer 1

Your question is vague and ambiguous. I'll leave the timezone ambiguity away.

How can I convert time in unix timestamp to normal time?

I suspect that you're somehow obtaining a long or maybe a String value from the DB instead of a Date. In JDBC, you would normally like to use the appropriate methods to obtain the DB-specific datatypes. The MySQL TIMESTAMP datatype can be obtained by ResultSet#getTimestamp() which gives you a java.sql.Timestamp which in turn is a subclass of java.util.Date.

In a nut, the following should do:

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

To format it further in a human readable format whenever you're going to present it to the enduser, use SimpleDateFormat. Click the link, it contains an overview of all patterns. Here's an example:

String dateString = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(date);

To do all the other way round, use respectively SimpleDateFormat#parse() and PreparedStatement#setTimestamp().

Answer 2

Unix timestamp is seconds since "epoch". Java's currentTimeMillis are milliseconds since "epoch". You can get a Java Date object with a simple multiplication like this:

 Date dateFromUnixTime = new Date( 1000l * unixTime) ;

From there, you can format it using the normal date formatting tools in Java.