I am trying to run this query in Sql Server and it is trough me an error saying 'longtodate' is not a recognized built-in function name.' Can you please me out in fixing this .
SELECT wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",cd.CATEGORYNAME "Category",wo.TITLE "Subject",ti.FIRST_NAME "Technician",pd.PRIORITYNAME "Priority",std.STATUSNAME "Request Status",std.ISPENDING "Pending Status",longtodate(wo.CREATEDTIME) "Created Time",longtodate(wo.COMPLETEDTIME) "Completed Time",wo.TIMESPENTONREQ "Time Elapsed",longtodate(wos.LAST_TECH_UPDATE) "Last Update Time",wotodesc.FULLDESCRIPTION "Description" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN WorkOrderToDescription wotodesc ON wo.WORKORDERID=wotodesc.WORKORDERID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID 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 WHERE (((longtodate(wo.CREATEDTIME) >= datetolong('1420952400000') AND ((longtodate(wo.CREATEDTIME) != 0) AND (longtodate(wo.CREATEDTIME) IS NOT NULL))) AND ((longtodate(wo.CREATEDTIME) <= datetolong('1451624399000') AND (((longtodate(wo.CREATEDTIME) != 0) AND (longtodate(wo.CREATEDTIME) IS NOT NULL)) AND (longtodate(wo.CREATEDTIME) != -1)))) AND wo.ISPARENT='1'
Thank you,
Sri