How Do I Get the Current Month in Sql

SELECT Agentname,cast(Sum(agentAmount) as int) as Tolling.from TABLENAME where datepart(mm,DATEFIELDNAME) =month(getdate())and datepart(yyyy,DATEFIELDNAME) =year(getdate())group by agentname order by Tolling desc.

How do I get the current month in SQL Query?

1. SELECT Agentname,cast(Sum(agentAmount) as int) as Tolling.
2. from TABLENAME where datepart(mm,DATEFIELDNAME) =month(getdate())
3. and datepart(yyyy,DATEFIELDNAME) =year(getdate())
4. group by agentname order by Tolling desc.

How do I get the current month start and end date in SQL Server?

1. DECLARE @myDate DATETIME = ’02/15/2020′; — its mm/dd/yyyy format. …
2. SELECT DATEADD(DD,-(DAY(GETDATE() -1)), GETDATE()) AS FirstDate SELECT DATEADD(DD,-(DAY(GETDATE())), DATEADD(MM, 1, GETDATE())) AS LastDate.