Q&A for people seeking specific software recommendations
SELECT Id, CONVERT(DATE, CreationDate) AS CreationDate FROM Users WHERE CONVERT(DATE, CreationDate) = '2021-12-23';