Редактирование: MySQL (раздел)

===== DATE() =====

You can however also select people who were first seen on a particular date. You'll need to use a function for that tho:

SELECT *<br>
FROM ss13_player<br>
WHERE DATE(firstseen) = "2013-04-19"

This will return a list of players who were first seen on 19 April 2013. If you want to get people who joined after April 17 2013, execute the following: (NOTE, This will only show people who joined on 18 April or later! Use >= if you want to include 17 April.)

SELECT *<br>
FROM ss13_player<br>
WHERE DATE(firstseen) > "2013-04-17"