First day of the next month

sql, sql-date-functions, sql-server, t-sql

Solution

First day of next month:

sql-server 2012+

DATEADD(d, 1, EOMONTH(current_timestamp))

sql-server 2008 and older:

DATEADD(m, DATEDIFF(m, -1, current_timestamp), 0)

Problem

I'm trying get the results where it only displays OrderDates before the LAST day of the CURRENT month. I'm guessing it would be like this... ``` SELECT OrderDate FROM Orders WHERE OrderDate < (code for first day of the next month?) ```

Original source