Just out of curiosity, WHY do you not want to store the time? I mean, storing a 0 time doesn't save you any space. It's easy enough to use the DATEPART functions when comparing the values, to ignore the time portion. I might see some advantage to indexing, but that's about it.