Other YEAR SQL function

1. Usage of YEAR to show order's year

SQL Server Query 1

            
 SELECT  

     OrderID,  

     OrderDate,  

     YEAR(OrderDate) AS OrderYear,  

     MONTH(OrderDate) AS OrderMonth,  

     DATENAME(MONTH, OrderDate) AS OrderMonthName,  

     ShippedDate,  

     YEAR(ShippedDate) AS ShipYear,  

     MONTH(ShippedDate) AS ShipMonthNumber,  

     DATENAME(MONTH, ShippedDate) AS ShipMonthName  

 FROM Orders  

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

            
        

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .Select()  

     .Column(new SYSDATETIME(), "SystemDateTime")  

     .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT OrderID AS OrderID,
       OrderDate AS OrderDate,
       YEAR(OrderDate) AS OrderYear,
       MONTH(OrderDate) AS OrderMonth,
       DATENAME(month, OrderDate) AS OrderMonthName,
       ShippedDate AS ShippedDate,
       YEAR(ShippedDate) AS ShipYear,
       MONTH(ShippedDate) AS ShipMonthNumber,
       DATENAME(month, ShippedDate) AS ShipMonthName
FROM Orders
WHERE OrderID IN (@pMAIN_2603210529026357300, @pMAIN_2603210529026357301, @pMAIN_2603210529026357302, @pMAIN_2603210529026357303, @pMAIN_2603210529026357304);


            
        

Parameters (If used)

Query Results 1: