April 14, 2011

ORDER By on Converted Date in SQL Server

SELECT CONVERT(NVARCHAR(30),TDATE,106) FROM ComplaintDetails
WHERE
TDATE BETWEEN @FDATE AND @TDATE
GROUP BY CONVERT(NVARCHAR(30),TDATE,106)
ORDER BY CAST( CONVERT(NVARCHAR(30),TDATE,106) AS DATETIME)

No comments:

Post a Comment