DateTime Field Hide time if it is midnight

SQLServerCentral » Latest topics

DateTime Field Hide time if it is midnight

I need a query to hide the time from a datetime field if the time is midnight.
I tried a case statement but that didn't work any ideas?

Thanks

more info...