Select distinct date?

[blurMember]

I hope I am in the right forum. My data type column from the table ClockIn_Date is DateTime. The dropdownlist seems to select distinct date+time. I want to only select distinct the date and not inclusive of the time. What is the correct sql statement? SELECT DISTINCT ClockIn_Date FROM dbo.Stud_ClockIn

thanks in advance. Much appreciated.

[Sebastian T Xavier]

try this select distinct convert(char(10),clockin_date,101) from dbo.Stud_ClockIn and do reply

[Muhammad Chitrali]

It's not working...

[_AK_]

Its working fine.. What exactly are you using?

Best Regards, Apurva Kaushal