Get month and year from a datetime in SQL Server 2005

datepart(year,getdate()) - returns year in int

datepart(month,getdate()) - returns month in int

datename(month,getdate()) - returns month name in string

Regards,

Prajanuranjan...