我使用python从数据库中发送了一个列表中的日期时间值,其格式如下。我现在想在图表中显示这些。
datasets: [{
label: '# temperature',
data: [datetime.datetime(2020, 4, 1, 9, 18, 58), datetime.datetime(2020, 4, 1, 9, 21, 1), datetime.datetime(2020, 4, 1, 10, 26, 56), datetime.datetime(2020, 4, 1, 10, 27, 9), datetime.datetime(2020, 4, 1, 10, 27, 35), datetime.datetime(2020, 4, 1, 10, 31, 6), datetime.datetime(2020, 4, 2, 17, 47, 4), datetime.datetime(2020, 4, 2, 17, 48, 18), datetime.datetime(2020, 4, 2, 17, 48, 56)]
您可以使用moment.js:
<script src="http://cdnjs.cloudflare.com/ajax/libs/moment.js/2.13.0/moment.min.js"></script>
然后在图表脚本中使用moment()
,如下例所示
请注意,月份是0索引的,因此您需要从Python月份中减去1。
<script>
var dayFormat = 'YYYY-MM-DD hh:mm:ss';
function newDateString(year, month, day, hour, minute, second) {
return moment().year(year).month(month).date(day).hour(hour).minute(minute).second(second).format(dayFormat);
};
var data = {
labels: [ {% for item in labels %}
newDateString( {{ item.year }},
{{ item.month - 1 }},
{{ item.day }},
{{ item.hour }},
{{ item.minute }},
{{ item.second }}
),
{% endfor %}
],
series: [ {% for item in series %}
{{ item }},
{% endfor %}
]
};
var options = {
width: "640px",
height: "320px"
};
// Create a new line chart object where as first parameter we pass in a selector
// that resolves to our chart container element. The Second parameter
// is the actual data object.
new Chartist.Line('#chart1', data);
</script>