Q&A for professional and enthusiast programmers
SELECT DISTINCT CONVERT(DATE, CreationDate) AS date FROM Posts WHERE OwnerUserId = ##UserId## ORDER BY 1