no value for timestamp
Please help with this sample query.
I want to display a report if the there is no responded time, it will display 'not assigned' or zero (0). With the query below, if there's no response to a request, it will display 01-01-1970.
SELECT WO.WORKORDERID, WO.REQUESTERID, DATE_FORMAT(FROM_UNIXTIME(WO.CREATEDTIME/1000),'%m-%d-%Y %k:%i') 'Created Time', DATE_FORMAT(FROM_UNIXTIME(WO.RESPONDEDTIME/1000),'%m-%d-%Y %k:%i') 'RESPONDED TIME', WO.COMPLETEDTIME FROM WORKORDER WO WHERE WO.WORKORDERID=72292
I want to display a report if the there is no responded time, it will display 'not assigned' or zero (0). With the query below, if there's no response to a request, it will display 01-01-1970.
SELECT WO.WORKORDERID, WO.REQUESTERID, DATE_FORMAT(FROM_UNIXTIME(WO.CREATEDTIME/1000),'%m-%d-%Y %k:%i') 'Created Time', DATE_FORMAT(FROM_UNIXTIME(WO.RESPONDEDTIME/1000),'%m-%d-%Y %k:%i') 'RESPONDED TIME', WO.COMPLETEDTIME FROM WORKORDER WO WHERE WO.WORKORDERID=72292