select distinct rev_actor
from revision
where rev_timestamp >=... |
1 year ago |
select distinct rev_actor
from revision
where rev_timestamp >=... |
1 year ago |
SELECT UNHEX(DATE_FORMAT(NOW(), '%Y%m%d%H%i%s')) AS timestamp;
|
1 year ago |
SELECT DATE_FORMAT(NOW(), '%Y%m%d%H%i%s') AS timestamp;
|
1 year ago |
SELECT DATE_FORMAT(NOW(), '%YmdHis') AS timestamp;
|
1 year ago |
SELECT UNHEX(DATE_FORMAT(NOW(), '%YmdHis')) AS binary_timestamp;
|
1 year ago |