Hi
Does anyone know how to select all results in a table from the start of that month.
I already use a query which selects all resuts from the start of the day (see below) so I am looking for something similar if possible.
SELECT count(id) FROM page_views WHERE time_stamp > CURRENT_DATE()
Does anyone know how to select all results in a table from the start of that month.
I already use a query which selects all resuts from the start of the day (see below) so I am looking for something similar if possible.
SELECT count(id) FROM page_views WHERE time_stamp > CURRENT_DATE()