Queries the SQL statement of the month of the current year for a given date.

Query the SQL statement declare @ datedatetime; set @ dategetdate () selectdatepart (month, @ date) [monthofyear]; -- returns the int type selectdatename (month, @ date) [monthofyear]; -- returns the varchar selectmonth (@ query the SQL statement for which the given date is the month of the current year

Declare @ date datetime;
Set @ date = getdate ()
Select datepart (month, @ date) [monthofyear]; -- Return int type
Select datename (month, @ date) [monthofyear]; -- returns the varchar type.
Select month (@ date) [monthofyear]; -- Return int type
Go