0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Japanese language

SELECT Creationdate, CONCAT(YEAR(CreationDate),RIGHT(CONCAT(0,MONTH(CreationDate)),2)) as Periods
FROM Posts




/*SELECT Count(ID) as Skaits
FROM Users
WHERE UPPER(DisplayName) LIKE 'ANDR%'*/



/*SELECT Count(ID) as Skaits
FROM Posts
WHERE CreationDate BETWEEN '2019/01/01 00:00:00' AND '2019/12/31 23:59:59'*/


/*SELECT DISTINCT TagID, TagName
from PostTags
INNER JOIN Tags
ON PostTags.TagID=Tags.ID
ORDER BY TagID*/

fork query

edited dec 6

created dec 6 anonymous