by ssi
11. February 2016 09:28
--First of Current Month
--First of Current Month
select DATEADD(month, DATEDIFF(month, 0, GETDATE()), 0) as Firstday
,dateadd(day, -1, dateadd(month, 1, dateadd(day, 1 - day(GETDATE()), GETDATE()))) as lastday
d859f730-da5f-4129-95ce-9b3dc06fd00b|0|.0|96d5b379-7e1d-4dac-a6ba-1e50db561b04
Tags: SQL, DATE
CSharp | SQL
Subscribe