Java convert for a long time to java.util.Date

Question

why is it different:
 select from_unixtime(1383699655)i get '2013-11-06 09:00:55', but when i convert 1383699655 to
java.util.Date,new Date(1383699655)i getSat Jan 17 08:21:43 CST 1970

Answer 1

The unix timestamp is in seconds, and java Dateis in milliseconds.

So you have to convert

 new Date(1383699655 * 1000L)

Answer 2

Java time - milliseconds since January 1, 1970 00:00. Unix time is seconds. Multiply by 1000.