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?
Sql – Get month and year from a datetime in SQL Server 2005
sqlsql server
Related Topic
- Sql-server – How to check if a column exists in a SQL Server table
- Sql – How to concatenate text from multiple rows into a single text string in SQL Server
- Sql – Parameterize an SQL IN clause
- Sql-server – LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
- Sql-server – the best way to auto-generate INSERT statements for a SQL Server table
- Sql – How to UPDATE from a SELECT in SQL Server
- Sql – What are the options for storing hierarchical data in a relational database
- Sql – How to delete using INNER JOIN with SQL Server
Best Answer