DATEFROMPARTS SQL function

1. Usage of DATEFROMPARTS which shows various way to display Employee Hire Date.

SQL Server Query 1

            
SELECT  

    EmployeeID, FirstName, LastName, HireDate,  -- Original HireDate for comparison  

    DATEFROMPARTS(  

        YEAR(HireDate),  -- Extract year from HireDate  

        MONTH(HireDate), -- Extract month from HireDate  

        DAY(HireDate)    -- Extract day from HireDate  

    ) AS ReconstructedHireDate,  

    --  Example: Construct a date 5 years after the original HireDate  

    DATEFROMPARTS(  

        YEAR(HireDate) + 5,  

        MONTH(HireDate),  

        DAY(HireDate)  

    ) AS FiveYearsLater  

FROM Employees  

ORDER BY EmployeeID;  

            
        

Create SQL query with SqlQueryBuilder 1

            
var (sql1, parameters1) = new SqlQueryBuilder()  

    .Select()  

    .Columns("EmployeeID", "FirstName", "LastName", "HireDate")  

    .Column(new DATEFROMPARTS(new YEAR(new Column("HireDate")), new MONTH(new Column("HireDate")), new DAY(new Column("HireDate")))  

    , "ReconstructedHireDate")  

    .Column(new DATEFROMPARTS(new YEAR(new Column("HireDate")).AddArithmatic(new Arithmatic().Add(5)), new MONTH(new Column("HireDate")),   

        new DAY(new Column("HireDate")))  

    , "FiveYearsLater")  

    .From("Employees")  

    .OrderBy(new OrderBy().Set(new Column("EmployeeID")))  

    .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT EmployeeID,
       FirstName,
       LastName,
       HireDate,
       DATEFROMPARTS(YEAR(HireDate), MONTH(HireDate), DAY(HireDate)) AS ReconstructedHireDate,
       DATEFROMPARTS(YEAR(HireDate) + @pMAIN_2507192046044121860, MONTH(HireDate), DAY(HireDate)) AS FiveYearsLater
FROM Employees
ORDER BY EmployeeID ASC;


            
        

Parameters (If used)

Query Results 1: