Q&A about the site for developers and users of elementary OS and applications
SELECT distinct FORMAT (d.CreationDate, 'yyyy-MM-dd') as [date1], FORMAT (d.CreationDate, 'yyyy-MM') as [date2], (d.Id) as id, d.Title, d.Body, d.Tags, Score, AnswerCount, CommentCount, FavoriteCount FROM Posts d WHERE d.PostTypeId = 1 -- 1=Question and d.CreationDate >= '2021-03-01' and (d.Title like '%Codespaces%') order by FORMAT (d.CreationDate, 'yyyy-MM-dd')