Google

Friday, October 7, 2011

MS SQL - Convert Date to Month Name and sort

Convert date to month:
DATENAME(month, TableName.DateFieldName) AS [Month Name]

Full statement with sorting by month:
 
SELECT     DATENAME(month,
TableName.DateFieldName) AS [Month Name]
FROM        
TableName
ORDER BY MONTH(
TableName.DateFieldName)



No comments:

Post a Comment