Date/time not being displayed in custom report
I am running the following custom query:
The Created time always comes out as blank (see attached screenshot). In fact, I can just run a simple query like:
and the Created time displays as blank. Exporting either of these to Excel yields nothing in the created column.
Running either of these in the MySQL Query Browser yields the expected (good) results. Any suggestions?
Select A.title AS RequestTitle, FROM_UNIXTIME(A.createdtime/1000) AS Created,
B.first_name AS Technician, C.first_name AS Requester
from aaauser as C INNER JOIN
(workorder as A INNER JOIN (workorderstates as D INNER JOIN aaauser as B on D.ownerid = B.user_id) on
A.workorderid = D.workorderid) on C.user_id = A.requesterid
ORDER BY Requester;
The Created time always comes out as blank (see attached screenshot). In fact, I can just run a simple query like:
Select FROM_UNIXTIME(createdtime/1000) AS Created FROM workorder;
and the Created time displays as blank. Exporting either of these to Excel yields nothing in the created column.
Running either of these in the MySQL Query Browser yields the expected (good) results. Any suggestions?