[Solved]-How to get time and value from MySQL into Highcharts-Highcharts

I think you have to use Highcharts.dateFormat.

Below is example which i am using.

xAxis: [{
                    categories: categories,
                    labels: {
                        formatter: function() {
                            return Highcharts.dateFormat('%H:%M', this.value);
                        },
                        style: {
                            'font-size': '11px',
                        },
                    },
                    type: 'datetime',


       }],

Hope this will helpful to you.

I've managed to get it working.

Issues were the extra square brackets on the json and the "" round the temperature values.

Issue with the x axis as in the pointInterval being set to day rather than hour.

Working code below

   $(document).ready(function() {

var options = {
    chart: {
        renderTo: 'container',
        type: 'spline'
    },
    title: {
      text: 'Temperature'
    },
    subtitle: {
      text: 'Todays temperature trend'
    },
    xAxis: {
        type: 'datetime',
        dateTimeLabelFormats: {
            hour: '%H:%M'
        },
        title: {
            text: 'Time'
        }
    },
    yAxis: {
        title: {
            text: 'Temperature (c)'
        }},
        tooltip: {
           valueSuffix: ' c'
       },
    series: [{name: 'Temperature', pointStart: Date.UTC(2017, 2, 17, 1),
    pointInterval: 3600 * 1000}]
};

$.getJSON('temp.json', function(data) {
    options.series[0].data = data;
    var chart = new Highcharts.Chart(options);
});

});