Other DAY SQL function

1. Usage of DAY to show Order Statistics

SQL Server Query 1

            
 SELECT  

     OrderID,  

     OrderDate,  

     DAY(OrderDate) AS DayOfMonth,  

     ShippedDate,  

     DAY(ShippedDate) AS ShipDayOfMonth  

 FROM Orders  

 WHERE OrderID IN (10248, 10249, 10250, 10251, 10252);  

            
        

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .Select()  

     .Columns(" OrderID", "OrderDate")  

     .Column(new DAY(new Column("OrderDate")), "DayOfMonth")  

     .Column("ShippedDate", "ShippedDate")  

     .Column(new DAY(new Column("ShippedDate")), "ShipDayOfMonth")  

     .From("Orders")  

     .Where(new Where(new IN(new Column("OrderID"), 10248, 10249, 10250, 10251, 10252)))  

     .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT OrderID,
       OrderDate,
       DAY(OrderDate) AS DayOfMonth,
       ShippedDate AS ShippedDate,
       DAY(ShippedDate) AS ShipDayOfMonth
FROM Orders
WHERE OrderID IN (@pMAIN_2507192055432802960, @pMAIN_2507192055432802961, @pMAIN_2507192055432802962, @pMAIN_2507192055432802963, @pMAIN_2507192055432802964);


            
        

Parameters (If used)

Query Results 1: