EOMONTH SQL function

1. Usage of EOMONTH which shows various way to display order date.

SQL Server Query 1

            
SELECT  

    o.OrderID,  

    o.OrderDate,  

    EOMONTH(o.OrderDate) AS EndOfMonth,  

    EOMONTH(o.OrderDate, 1) AS EndOfNextMonth,  

    EOMONTH(o.OrderDate, -1) AS EndOfPreviousMonth  

FROM Orders o;  

            
        

Create SQL query with SqlQueryBuilder 1

            
var (sql1, parameters1) = new SqlQueryBuilder()  

    .Select()  

    .Columns("o.OrderID","o.OrderDate")  

    .Column(new EOMONTH(new Column("o.OrderDate")), "EndOfMonth")  

    .Column(new EOMONTH(new Column("o.OrderDate"), 1), "EndOfNextMonth")  

    .Column(new EOMONTH(new Column("o.OrderDate"), -1), "EndOfPreviousMonth")  

    .From("Orders", "o")  

    .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT o.OrderID,
       o.OrderDate,
       EOMONTH(o.OrderDate, 0) AS EndOfMonth,
       EOMONTH(o.OrderDate, 1) AS EndOfNextMonth,
       EOMONTH(o.OrderDate, -1) AS EndOfPreviousMonth
FROM Orders AS o;


            
        

Parameters (If used)

Query Results 1:

2. Usage of EOMONTH to show remaining days in the order's month.

SQL Server Query 2

            
SELECT  

    o.OrderID,  

    o.OrderDate,  

    EOMONTH(o.OrderDate) AS EndOfMonth,  

    DATEDIFF(day, o.OrderDate, EOMONTH(o.OrderDate)) AS DaysRemainingInMonth  

FROM Orders o;  

            
        

Create SQL query with SqlQueryBuilder 2

            
var (sql2, parameters2) = new SqlQueryBuilder()  

    .Select()  

    .Columns("o.OrderID", "o.OrderDate")  

    .Column(new EOMONTH(new Column("o.OrderDate")), "EndOfMonth")  

    .Column(new DATEDIFF(SqlDateInterval.day,new Column("o.OrderDate"), new EOMONTH(new Column("o.OrderDate"))) , "DaysRemainingInMonth")  

    .From("Orders", "o")  

    .Build();  

            
        

Query build by SqlQueryBuilder 2

            
SELECT o.OrderID,
       o.OrderDate,
       EOMONTH(o.OrderDate, 0) AS EndOfMonth,
       DATEDIFF(day, o.OrderDate, EOMONTH(o.OrderDate, 0)) AS DaysRemainingInMonth
FROM Orders AS o;


            
        

Parameters (If used)

Query Results 2: