The Tech Pursuit
The Dev Shelf
Pages
Home
Interview Questions
About Me
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment