SK
.
SHATRUGHNA
KUMAR
ARCHITECTURE / ENGINEERING
Home
Expertise
Insights
About
Let's connect ↗
The Tech Pursuit
The Dev Shelf
Pages
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