by uumesama » Tue Sep 24, 2013 1:26 pm
Heres a weird one for you I hope.
Im running a query -
SELECT CASTproductiondate AS Date ProdDate, CONVERTchar8, DATEADDsecond, jobduration, 0:00:00, 108 Duration FROM jobstatistics
JOIN jobdetails ON jobstatistics.jobdetail_id = jobdetails.jobdetail_id
WHERE jobdetails.jobdetail_id = xxxxx AND jobstatistics_duration IS NOT NULL ORDER BY jobstatistics_productiondate
Running the query is fine. I get 2 columns. 1 with the date and 1 with the Duration converted from its native seconds to HH:MM:SS.
Problem is, when I then try to chart that so it had ProdDate along the X and Duration along the Y its not displaying the Duration info. If I remove the conversion so its just
SELECT CASTproductiondate AS Date ProdDate, jobduration Duration FROM jobstatistics
JOIN jobdetails ON jobstatistics.jobdetail_id = jobdetails.jobdetail_id
WHERE jobdetails.jobdetail_id = xxxxx AND jobstatistics_duration IS NOT NULL ORDER BY jobstatistics_productiondate
The information displays correctly in both the query results and the chart.
Help?