<tutorialjinni.com/>

MySQL Select 1st Day of Month and Current Time

Posted Under: Database, MySQL, Snippets on Aug 29, 2018
MySQL snippet to select data between first day of the current month and current date.
SELECT * FROM TABLE_NAME WHERE DATE_COLUMN BETWEEN 
DATE_SUB(CURRENT_DATE, INTERVAL DAYOFMONTH(CURRENT_DATE)-1 DAY) and CURRENT_DATE
© Tutorial Jinni