javascript - Google Charts API datetime unix format? - Stack Overflow

admin管理员组

文章数量:1313799

I'm having a hard time getting Google Charts to understand the datetime format. I used an example [1] where the datetime format is set to a simple month day and year, but I changed it to take an input of type datetime. An example is available the following page:

.php

The start of the code is as follows:

data.addColumn('datetime', 'Date');
data.addColumn('number', 'Active or not');      
data.addRows(1768);
data.setValue(0, 0, new Date(1306192258));
data.setValue(0, 1, 1);

Why will Google change that Date format to Jan 15, 1970? (Start of Epoch time?)

Thanks!

[1]

I'm having a hard time getting Google Charts to understand the datetime format. I used an example [1] where the datetime format is set to a simple month day and year, but I changed it to take an input of type datetime. An example is available the following page:

http://www.sccs.swarthmore.edu/users/09/leo/cgi-bin/viewer.php

The start of the code is as follows:

data.addColumn('datetime', 'Date');
data.addColumn('number', 'Active or not');      
data.addRows(1768);
data.setValue(0, 0, new Date(1306192258));
data.setValue(0, 1, 1);

Why will Google change that Date format to Jan 15, 1970? (Start of Epoch time?)

Thanks!

[1] http://www.beakkon./geek/how-to/create-interactive-charts-using-google-charts-api

• javascript
• google-api
• google-visualization

Share Improve this question Follow asked May 27, 2011 at 22:15 RioRio 14.9k2222 gold badges7171 silver badges109109 bronze badges

Add a ment  | 

2 Answers 2

Sorted by: Reset to default 5

Try this:

data.addColumn('datetime', 'Date');
data.addColumn('number', 'Active or not');      
data.addRows(1768);
var d = new Date();
d.setTime(1306192258*1000);
data.setValue(0, 0, d);
data.setValue(0, 1, 1);

Some more info on the Javascript Date function can be found w3schools. website I found - new Date("July 21, 2011 02:00:00") to be a good promise for what I wanted to do.

Snippet of my code

data.addRows([
[new Date("July 21, 2011 00:00:00"), 0.319636363636 ],
[new Date("July 21, 2011 07:00:00"), 0.319636363636 ],
[new Date("July 21, 2011 22:00:00"), 0.319636363636 ],
[new Date("July 21, 2011 23:00:00"), 0.319636363636 ],
[new Date("July 22, 2011 09:00:00"), 0.319636363636 ],
[new Date("July 22, 2011 10:00:00"), 0.319636363636 ]
]);

本文标签： javascriptGoogle Charts API datetime unix formatStack Overflow