Converting Integer time stamp into java date

Question

I have following time stamp in Integer form

1333125342

I can convert it using SQL:

select DATEADD(ss, FlOOR(1333089223/86400)*86400, '1970-01-01 00:00:00') AS Date

How to convert it in java? So that it would return value:

3/30/12 12:18:43 PM

what does `1333125342` represent ? – jmj May 07 '12 at 06:36 — jmj, May 07 '12 at 06:36
@JigarJoshi its integer value of timestamp – kinkajou May 07 '12 at 06:38 — kinkajou, May 07 '12 at 06:38
doesn't seem likely: `date: invalid date `1333125342'` – Visionary Software Solutions May 07 '12 at 06:39 — Visionary Software Solutions, May 07 '12 at 06:39

score 22 · Accepted Answer · answered May 07 '12 at 06:40

22

Assuming its the time since 1/1/1970 in seconds. you can try

String dateAsText = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
                          .format(new Date(1333125342 * 1000L));

answered May 07 '12 at 06:40

Peter Lawrey

525,659
79
751
1,130

4

The `L` represents that the 1000 is a `long` without this you are likely to get an overflow when you multiply an `int` * `int` but an `int` * `long` will result in a `long` which won't overflow. – Peter Lawrey May 07 '12 at 06:48
2

1333125342 * 1000 is 1685480240 (due an overflow) 1333125342 * 1000L is 1333125342000L – Peter Lawrey May 07 '12 at 06:50
thanks for `1000L` explanation. Any official link for the same? – Sumit Ramteke Mar 02 '17 at 11:24
1

@SumitRamteke I would read the source for RollCycle and RollCycles as most of the code is a one liner. – Peter Lawrey Mar 02 '17 at 11:55

jmj · Answer 2 · 2012-05-07T06:42:12.587

2

if it is milliseconds value represents the number of milliseconds that have passed since January 1, 1970 00:00:00.000 GMT

then simply use

new java.util.Date(millis);

and if you need it in particular format

3/30/12 12:18:43 PM

then use SimpleDateFormat to format the Date to desired formatted String

edited May 07 '12 at 06:42

answered May 07 '12 at 06:40

jmj

237,923
42
401
438

1

if not process it accordingly to convert it into such millis – jmj May 07 '12 at 06:40
it return 1970-01-16 15:48:09 but the value is 3/30/12 12:18:43 PM – kinkajou May 07 '12 at 06:43
1

You need to know what this number represents, and then see my above comment, You need to multiply with 1000L as peter suggested – jmj May 07 '12 at 06:44

score 0 · Answer 3 · answered May 07 '12 at 06:43

That timestamp contains the seconds elapsed since 1970-1-1 0:00 UTC.

To convert it to a Java Date instantiate a new Date Object (see Java doc) and invoke setTime() on that. Note, that setTime expects milliseconds instead of seconds, so you would have to multiply your timestamp by 1000.

The toString() method yields something readable.

Converting Integer time stamp into java date

3 Answers3

Linked

Related