0

Please login or register to vote for this query.

(click on this box to dismiss)

Returns amount of days when you've posted at least one answer.

Q&A for scientists using computers to solve scientific problems

-- How many days was I active?
-- Returns amount of days when you've posted at least one answer.

SELECT COUNT(DISTINCT CONVERT(char(10), CreationDate, 111)) AS days
FROM Posts
WHERE OwnerUserId = ##UserId##
-- GROUP BY CONVERT(char(10), CreationDate, 111)

-- Without DISTINCT this returns amount of posts per day in spite of GROUP BY.

fork query

edited mar 16 13 Tuxdude

created jun 8 10 Mark Hurd