Convert CREATEDTIME to readable format

Convert CREATEDTIME to readable format

I am trying to run a custom report from our MS SQL Server and the dates are important. All of our ticket's CREATEDTIME show up as "1169135575865"
 
I have the SQL statement below that gives me any ticket created between 1-1-2007 and 3-21-2010 which is working perfectly. Now I need a method to display the CREATEDTIME in a readable format such as 3/31/2010. Ultimately I want to group tickets based on CREATEDTIME into each month.
 
WHERE DATEADD(s,WorkOrder.CREATEDTIME/1000,'01-01-1970') >= convert(varchar,'2007-01-01',21) and DATEADD(s,WorkOrder.CREATEDTIME/1000,'01-01-1970') <= convert(varchar,'2010-03-31',21)
 
Thank you!
 

        New to M365 Manager Plus?
        New to M365 Manager Plus?
          New to RecoveryManager Plus?
          New to RecoveryManager Plus?
            New to Exchange Reporter Plus?
            New to Exchange Reporter Plus?
              New to SharePoint Manager Plus?
              New to SharePoint Manager Plus?
                See all integrations
                New to ADManager Plus?
                See all integrations
                New to ADManager Plus?

                  New to ADSelfService Plus?

                  Start your free trial
                  Start your free trial

                        Related Products