DATEPART SQL function

1. Usage of DATEPART for day of hiring details of employees.

SQL Server Query 1

            
SELECT  

    EmployeeID,  

    FirstName,  

    LastName,  

    HireDate,  

    DATEPART(weekday, HireDate) AS HireDayOfWeekNumber,  

    DATEPART(month, HireDate)   AS HireMonthNumber,  

    DATEPART(year,  HireDate)   AS HireYear,  

    DATEPART(quarter, HireDate) AS HireQuarter  

FROM Employees  

ORDER BY EmployeeID;  

            
        

Create SQL query with SqlQueryBuilder 1

            
var (sql1, parameters1) = new SqlQueryBuilder()  

    .Select()  

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

    .Column(new DATEPART(SqlDateInterval.weekday, new Column("HireDate")), "HireDayOfWeekNumber")  

    .Column(new DATEPART(SqlDateInterval.month, new Column("HireDate")), "HireMonthNumber")  

    .Column(new DATEPART(SqlDateInterval.year, new Column("HireDate")), "HireYear")  

    .Column(new DATEPART(SqlDateInterval.quarter, new Column("HireDate")), "HireQuarter")  

    .From("Employees")  

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

    .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT EmployeeID,
       FirstName,
       LastName,
       HireDate,
       DATEPART(weekday, HireDate) AS HireDayOfWeekNumber,
       DATEPART(month, HireDate) AS HireMonthNumber,
       DATEPART(year, HireDate) AS HireYear,
       DATEPART(quarter, HireDate) AS HireQuarter
FROM Employees
ORDER BY EmployeeID ASC;


            
        

Parameters (If used)

Query Results 1: