sql - 从SQL Server 2005中的日期时间获取月份和年份(Get month and year from a datetime in SQL Server 2005)

Question

I need the month+year from the datetime in SQL Server like 'Jan 2008'.

(我需要SQL Server中日期时间的月份+年份，如'2008年1月'。)

I'm grouping the query by month, year.

(我按月，年分组查询。)

I've searched and found functions like datepart, convert, etc., but none of them seem useful for this.

(我搜索并找到了像datepart，convert等函数，但它们似乎都没有用。)

Am I missing something here?

(我在这里错过了什么吗？)

Is there a function for this?

(这有功能吗？)

  ask by Malik Daud Ahmad Khokhar translate from so

Answer 1

select 
datepart(month,getdate()) -- integer (1,2,3...)
,datepart(year,getdate()) -- integer
,datename(month,getdate()) -- string ('September',...)