Sorting question

Question

I have to "group by" purchase date, but the database's purchase date includes the time as well.  So when I group by purchase date, it includes the time as part of the date. Since the times are unique, I don't get "grouped by" info.  Is there a way to write a sql command to group by date while ignoring the time stamp?  The date part of the information consistently takes up the first 10 digits.

Thanks!!!

Answer 1

You're in wrong forum.

group by CAST(convert(varchar,purchaseDate,101)as datetime)

Answer 2

Hi,
Please use T-SQL forum for this.

As said by rok1 you can use

group by CAST(convert(varchar,purchaseDate,101)as datetime)

instead of group by purchaseDate

Please Vote & "Mark As Answer" if this post is helpful toyou.

Cheers
Bikash Dash
MCDBA/MCITP