I have a table that store a DateTime value. In my query, i want to get the DISTINCT value base on Date only, meaning i want to get a single record per day ignoring the Time value.
GPSDATA table values
SELECT DISTINCT `rdatetime` FROM `gpsdata`
I don't have SQL Server to test the query, but i believe this should work, please check on your side and let me know the result
SELECT DISTINCT DATE(rdatetime) FROM gpsdata