time errors in query
Trying to use msquery and excel to pull some data from SD+ and getting a strange result for the request created time. All my requests are showing as having been created at just 4 different days/times.
The SQL query i'm using is
SELECT aaauser_0.USER_ID, aaauser_0.FIRST_NAME, from_unixtime(aaauser_0.CREATEDTIME/1000) AS 'CREATED TIME', from_unixtime(workorderstates_0.ASSIGNEDTIME/1000) AS ' ASSIGNED TIME', workorderstates_0.WORKORDERID, workorderstates_0.CATEGORYID, workorderstates_0.OWNERID, workorderstates_0.STATUSID, workorderstates_0.PRIORITYID, workorderstates_0.LEVELID
FROM servicedesk.aaauser aaauser_0, servicedesk.workorderstates workorderstates_0
WHERE aaauser_0.USER_ID = workorderstates_0.OWNERID
ORDER BY workorderstates_0.WORKORDERID
i've added a screenshot showing the results in excel. Any ideas why the created time is like this?
The SQL query i'm using is
SELECT aaauser_0.USER_ID, aaauser_0.FIRST_NAME, from_unixtime(aaauser_0.CREATEDTIME/1000) AS 'CREATED TIME', from_unixtime(workorderstates_0.ASSIGNEDTIME/1000) AS ' ASSIGNED TIME', workorderstates_0.WORKORDERID, workorderstates_0.CATEGORYID, workorderstates_0.OWNERID, workorderstates_0.STATUSID, workorderstates_0.PRIORITYID, workorderstates_0.LEVELID
FROM servicedesk.aaauser aaauser_0, servicedesk.workorderstates workorderstates_0
WHERE aaauser_0.USER_ID = workorderstates_0.OWNERID
ORDER BY workorderstates_0.WORKORDERID
i've added a screenshot showing the results in excel. Any ideas why the created time is like this?