var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SELECT DISTINCT DATE with different time
Hi! Good Day!
What is the correct SELECT query if i want to count the distinct date from my table.
10/11/2005 5:14:48 PM
10/11/2005 5:24:48 PM
10/10/2005 5:14:30 PM
10/13/2005 5:15:02 PM
My query is something like this.
SELECT COUNT(DISTINCT DateField) FROM Table1
The result should be 3 and not 4
because there are 2 records with the same date, only different time.
select distinct convert(varchar,datetimefield,110) from table
Thanks for taking the time to answer my question.
My SELECT query is ok now.