Select distinct date?
Database
1
Posts
1
Posters
0
Views
1
Watching
-
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.