Format Date Column as MM/dd/yyyy in SQL Server

You need to change the OrderDate format at SQL level like this

--[dbo].[GetCustomersBetweenOrderDate_Pager] '1996-07-17','1996-012-05',1,500, NULL
--[dbo].[GetCustomersBetweenOrderDate_Pager] NULL,NULL,1,500, NULL
ALTER PROCEDURE [dbo].[GetCustomersBetweenOrderDate_Pager]
       @From DATETIME = NULL
      ,@To DATETIME = NULL
      ,@PageIndex INT = 1
      ,@PageSize INT = 10
      ,@RecordCount INT OUTPUT
AS
BEGIN
      SET NOCOUNT ON;
      
      SELECT ROW_NUMBER() OVER
      (
            ORDER BY OrderId ASC
      )AS RowNumber
      ,OrderId
      ,ShipName
      ,[ShipCity]
      ,CONVERT(VARCHAR(10),OrderDate,101) AS OrderDate
      INTO #Results
      FROM Orders
      WHERE  (OrderDate BETWEEN @FROM AND @TO)
        OR (@FROM IS NULL OR @TO IS NULL)
 
      SELECT @RecordCount = COUNT(*)
      FROM #Results 
          
      SELECT * FROM #Results
      WHERE RowNumber BETWEEN(@PageIndex -1) * @PageSize + 1 AND(((@PageIndex -1) * @PageSize + 1) + @PageSize) - 1
     
      DROP TABLE #Results    
END