<p>I need the month+year from the datetime in SQL Server like 'Jan 2008'. 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. Am I missing something here? Is there a function for this?</p>

That format doesn't exist. You need to do a combination of two things,
```
```
select convert(varchar(4),getdate(),100)  + convert(varchar(4),year(getdate()))
```
```