problem with due by time
Hi all i have the following query, but when the query runs the due by times shows as
any ideas how i can convert this to the a format such as 12/01/2017
Thanks
SELECT ti.FIRST_NAME AS "Technician", wo.WORKORDERID AS "Request ID", wo.TITLE AS "Subject", ti.FIRST_NAME AS "Technician", pd.PRIORITYNAME AS "Priority", wo.DUEBYTIME AS "DueBy Time", std.STATUSNAME AS "Request Status" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID WHERE ((((((std.STATUSNAME = '1 - New') OR (std.STATUSNAME = '2 - In Progress')) OR (std.STATUSNAME = '3 - With Requster')) OR (std.STATUSNAME = '4 - Onhold')) AND (qd.QUEUENAME = 'Servicedesk')) AND (ti.FIRST_NAME = 'Jason')) AND wo.ISPARENT='1' ORDER BY 1 NULLS FIRST , 6 NULLS FIRST