Java convert unix timestamp to wrong time

Question

I have unix timestammp stored in mysql. I am converting it into time. It displays wrong time.

Here is code:

Date date = new Date((long)timestamp*1000); 
SimpleDateFormat sdf = new SimpleDateFormat("h:mm a"); 
sdf.setTimeZone(TimeZone.getTimeZone("GMT+5:30"));
timeString = sdf.format(date);
System.out.println(timeString);`

timestamp is variable which contains unix timestamp.
Ex: for timestamp=1417437428505 it should show 6:07 PM and showing 12:31 AM

What is solution for it?

Jon Skeet · Accepted Answer · 2014-12-01 13:59:07Z

4

You're multiplying a timestamp which is already in milliseconds since the Unix epoch by 1000. You just want:

Date date = new Date(timestamp);

If you look at all of the date, not just the time, you'll see it's currently in 46886!

edited Dec 1, 2014 at 13:59

answered Dec 1, 2014 at 12:57

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

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

Comments

WidWing · Accepted Answer · 2014-12-01 13:00:27Z

1

Are You sure that need multiplied by 1000? I tried pass without multiplying Date date = new Date(timestamp); and it printed 6:07 PM

answered Dec 1, 2014 at 13:00

WidWing

1761 silver badge10 bronze badges

Comments

Gren · Accepted Answer · 2014-12-01 13:02:23Z

0

Remove multiply with 1000 in

Date date = new Date((long)timestamp*1000);

than it works.

answered Dec 1, 2014 at 13:02

Gren

1,8641 gold badge12 silver badges16 bronze badges

Collectives™ on Stack Overflow

Java convert unix timestamp to wrong time

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related