Getting all records from the beginning of the current month
I have a table where I'd like to just pull records that are new that month. I'm not too familiar with SQL functions but I'm assuming there's a way to grab the current month and year within SQL.
So instead of editing the query every month...
I'd like to do something like (making up the SQL functions)...
SELECT * FROM myTable WHERE DateCreated => '3/1/2014'
Anything available along these lines? Thanks!
SELECT * FROM myTable WHERE DateCreated => MAKEDATE(MONTH(NOW()), 1, YEAR(NOW()))