SDU Tools: StartOfMonth and EndOfMonth in T-SQL

added by DotNetKicks
4/5/2019 12:25:48 PM

1 Kicks, 379 Views

In our free SDU Tools for developers and DBAs, we have a large number of useful functions. The topic for today is two simple ones: StartOfMonth and EndOfMonth. SQL Server 2012 added a function EOMONTH. It returns the end of the month date for any given date.