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