>You do realize that result column is not datetime?
>
>>Thank you Bruce for a slick solution.
>>>

>>>SELECT  DISTINCT CONVERT(CHAR(10), MyDate, 120)
>>>

I do, but I should have emphasised that distinction to Einar. Thanks.