Hi,

I've copied the below query into SQL server to create a stored procedure and I am getting 'longtodate' and 'datetolong' is not a recognised built-in function name.

SELECT longtodate(wo.CREATEDTIME) "Created Time",wo.WORKORDERID "Request ID",longtodate(wo.CREATEDTIME) "Created Time",wo.TITLE "Subject",aau.FIRST_NAME "Requester",dpt.DEPTNAME "Department" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID=dpt.DEPTID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN ItemDefinition icd ON wos.ITEMID=icd.ITEMID WHERE  ((((aau.FIRST_NAME != N'BOL IT' COLLATE Latin1_General_CS_AI) AND (aau.FIRST_NAME != N'intellipool2' COLLATE Latin1_General_CS_AI)) OR (aau.FIRST_NAME IS NULL)) AND (((longtodate(wo.CREATEDTIME) >= datetolong('1420070400000') AND ((longtodate(wo.CREATEDTIME) != 0) AND (longtodate(wo.CREATEDTIME) IS NOT NULL))) AND ((longtodate(wo.CREATEDTIME) <= datetolong('1483228799000') AND (((longtodate(wo.CREATEDTIME) != 0) AND (longtodate(wo.CREATEDTIME) IS NOT NULL)) AND (longtodate(wo.CREATEDTIME) != -1)))))  AND wo.ISPARENT='1'  ORDER BY 1

Please can someone help me with changing the above query to MS SQL query.

Thanks

Ram