Title
What I'm thinking is to figure out the first day of three months until the last day of the month.
What do you do when you can take the first natural three months?
Reply to discussion (solution)
SELECT * Fromtbl_namewhere date >= date_format (Subdate (now (), INTERVAL 3 month), '%y-%m-%d ')
Or
SELECT * Fromtbl_namewhere date >= date_format (Subdate (now (), INTERVAL 3 month), '%y-%m-01 ')
SELECT * Fromtbl_namewhere date >= date_format (Subdate (now (), INTERVAL 3 month), '%y-%m-%d ')
Or
SELECT * Fromtbl_namewhere date >= date_format (Subdate (now (), INTERVAL 3 month), '%y-%m-01 ')
No, we're using algorithms to figure out what's in a week.
SELECT * Fromtbl_namewhere date >= date_format (Subdate (now (), INTERVAL 3 month), '%y-%m-%d ')
Or
SELECT * Fromtbl_namewhere date >= date_format (Subdate (now (), INTERVAL 3 month), '%y-%m-01 ')
No, we're using algorithms to figure out what's in a week.
By doing this, and then in three months.
Date ("Y-m", Strtotime ("-3 month")). " -01 "; The first day of three months ago
You have an algorithm for three months, don't you? Divert the whole chant.