get current month data in sql code example

Example 1: sql get month name

SELECT GETDATE() 'Today', FORMAT(GETDATE(),'MMMM') 'Month Name'

Example 2: get current month last date in sql server

SELECT EOMONTH('2019-02-15') end_of_month_feb2019;