SQL Group By DateTime (MS SQL Server 2000) [Resolved]

[szlamany]

Select and Group by...

Convert(varchar(10),document.published_Date,101)

Style 101 is mm/dd/yyyy

Pick any style you want - just make sure to not have a time part on it.