Member Avatar for zac_mathews

Hi
I am a J2ME developer I am new to Dani Web.
I am using chartapi.finance.yahoo.com to calculate and display chart.
My questions is how to convert TIMESTAMP value to a Java Date or Calendar Object ?.....


For Eg: URL GIVEN BELOW

http://chartapi.finance.yahoo.com/instrument/1.0/aapl/chartdata;type=quote;range=1d/csv/

Its output will be

uri:/instrument/1.0/aapl/chartdata;type=quote;range=1d/csv/
ticker:aapl
unit:MIN
timezone:EST
gmtoffset:-18000
previous_close:199.2300
Timestamp:1265207400,1265230800
labels:1265209200,1265212800,1265216400,1265220000,1265223600,1265227200,1265230800
values:Timestamp,close,high,low,open,volume
close:194.7100,200.1600
high:194.9800,200.2000
low:194.4200,200.0300
open:194.7599,200.1600
volume:7100,678600
1265207400,195.2600,195.4000,195.1000,195.1700,273700
1265207460,195.0400,195.2700,194.9200,195.2300,127500
.........


How to convert values hilighted in RED to Date or calendar Object?...

I Tried this

Calendar cal=Calendar.getInstance();
cal.setTime(new Date(1265207400));

But unfortunatly cal value is set to 15/Jan/1970 15:26:47.:ooh:

Danni Gurus please help....:|

Thanks in Advance

Zac

  • 2 Contributors
  • 4 Replies
  • 1K Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by zac_mathews
Member Avatar for ~s.o.s~

> My questions is how to convert TIMESTAMP value to a Java Date
> or Calendar Object ?.....

It seems that the Timestamp here refers to the Unix timestamp (which is the number of seconds elapsed since January 1, 1970 (midnight UTC/GMT). This is in contrast with the way Java timestamp works which is considered to be the number of milliseconds elapsed since January 1, 1970 (midnight UTC/GMT). Multiplying the returned value with 1000 should do the trick here.

Also, ensure that you don't fall in the trap of truncation while multiplying those values.

Date d = new Date(1265207400 * 1000); //is different from
Date d = new Date(1265207400 * 1000L); // or
Date d = new Date(1265207400000);

In case you are still wondering why, in the first declaration the integer result of 1265207400 * 1000 which is 1966688416 and not 1265207400000 , is passed to the Date constructor leading to erroneous results.

> Thanks in Advance

HTH

commented: This was very usefull and very helpful... Thanks SOS +0
Member Avatar for zac_mathews

THANK YOU VERY MUCH.....
ITS WORKING...... I AM SO HAPPY.....

I have posted this same issue in YDN they were not able to answer this issue......

Thanks a lot.....

Zac

Member Avatar for ~s.o.s~

THANK YOU VERY MUCH.....
ITS WORKING...... I AM SO HAPPY.....

You are welcome, but please do not to use red/bold text since it hurts the eyes.

I have posted this same issue in YDN they were not able to answer this issue......

Then you should post this solution or at least a link to this thread in your YDN thread to help those who end up facing a similar issue. :)

Member Avatar for zac_mathews

Then you should post this solution or at least a link to this thread in your YDN thread to help those who end up facing a similar issue. :)

I already done that on the same day ..

Check this out... :)

http://developer.yahoo.net/forum/index.php?showtopic=4457

(Warning:: lots of bright colors and bold fonts used in YDN ...:icon_cool:.. goggles adviced....I will avoid them next time..:))

Thanks again....

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.