Code: Select all
WHERE YEAR(entries.timestamp) = YEAR(CURRENT_DATE()) AND MONTH(entries.timestamp) = MONTH(CURRENT_DATE())
Code: Select all
WHERE YEAR(CURRENT_DATE(), MONTH(entries.timestamp) = MONTH(CURRENT_DATE()))
Code: Select all
WHERE YEAR(entries.timestamp) = YEAR(CURRENT_DATE()) AND MONTH(entries.timestamp) = MONTH(CURRENT_DATE())
Code: Select all
WHERE YEAR(CURRENT_DATE(), MONTH(entries.timestamp) = MONTH(CURRENT_DATE()))