Other DATENAME SQL function

1. Usage of DATENAME to show Employee Hiring Details

SQL Server Query 1

            
 SELECT  

     EmployeeID,  

     FirstName,  

     LastName,  

     HireDate,  

     DATENAME(weekday, HireDate) AS HireDayOfWeek,  

     DATENAME(month, HireDate)   AS HireMonthName,  

     DATENAME(year,  HireDate)   AS HireYear,  

     DATENAME(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 DATENAME(SqlDateInterval.weekday, new Column("HireDate")), "HireDayOfWeek")  

     .Column(new DATENAME(SqlDateInterval.month, new Column("HireDate")), "HireMonthName")  

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

     .Column(new DATENAME(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,
       DATENAME(weekday, HireDate) AS HireDayOfWeek,
       DATENAME(month, HireDate) AS HireMonthName,
       DATENAME(year, HireDate) AS HireYear,
       DATENAME(quarter, HireDate) AS HireQuarter
FROM Employees
ORDER BY EmployeeID ASC;


            
        

Parameters (If used)

Query Results 1: