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