[thelist] SQL Query - Select Distinct Dates in Date/Time Field

[Anthony Baratta]

At 08:37 AM 2/22/2002, Ben Dyer wrote:
>I have a table with a date/time stamp field in it.  I'm trying to select
>the distinct *dates* (not date/times) from the database.
>
>This was the query I was trying on a coworker's recommendation:
>
>SELECT          DISTINCT CONVERT(varchar, dtJoined, 101) AS dtJoinedDate
>               , dtJoined
>FROM            tblTable
>ORDER BY        dtJoined

Try this:

SELECT          DISTINCT CONVERT(varchar, dtJoined, 101) AS dtJoinedDate
FROM            tblTable
ORDER BY        CONVERT(varchar, dtJoined, 101)

---
Anthony Baratta
President
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."