I have a date/time field in my sql server. There are some records that only show the date but most show the date time and this is messing up some reports. I want to put in a time into the records that only have the date. Here is how I get the records with only a date: (DATEPART(hour, DateOfService) = 0)
AND (DATEPART(minute, DateOfService) = 0) AND (DATEPART(second, DateOfService) = 0)
Any idea on how I could do this.