SELECT
CONCAT(LEFT(log_timestamp, 6), "01") AS month,
COUNT(log_id) AS... |
7 years ago |
SELECT
CONCAT(LEFT(log_timestamp, 6), "01") AS month,
COUNT(log_id) AS... |
7 years ago |
SELECT
LEFT(log_timestamp, 6) AS month,
COUNT(log_id) AS actions,
... |
7 years ago |
SELECT
LEFT(log_timestamp, 6) AS month,
COUNT(log_id) AS actions,
... |
7 years ago |
SELECT EXTRACT(YEAR FROM DATE_FORMAT(log_timestamp,'%Y%m%d%H%i%s')) AS... |
7 years ago |