SELECT DATE(`log_timestamp`) as date, count(*) as num_patrol_actions FROM... |
7 years ago |
SELECT DATE(`log_timestamp`) as date, count(*) as num_patrol_actions,... |
7 years ago |
SELECT DATE(`log_timestamp`) as date, count(*) as num_patrol_actions,... |
7 years ago |
SELECT DATE(`log_timestamp`) as date, count(*) as num_patrol_actions,... |
7 years ago |
SELECT DATE(`log_timestamp`) as date, count(*) as num_patrol_actions FROM... |
7 years ago |
SELECT DATE(`log_timestamp`) as date, count(*) as num_patrol_actions FROM... |
7 years ago |
SELECT log_timestamp,DATE(log_timestamp) FROM logging limit 10; |
7 years ago |
SELECT log_timestamp,DATE(FROM_UNIXTIME(log_timestamp)) FROM logging limit 10; |
7 years ago |
SELECT EXTRACT( YEAR_MONTH_DAY FROM `log_timestamp` ) as yearmonth, count(*)... |
7 years ago |
SELECT EXTRACT( YEAR_MONTH FROM `log_timestamp` ) as yearmonth, count(*) as... |
7 years ago |
SELECT * FROM logging limit 10 |
7 years ago |
SELECT EXTRACT( YEAR_MONTH FROM `timestamp` ) as yearmonth, count(*) as... |
7 years ago |