two weeks ago data in mysql select code example
Example: select amount weeks between two dates mysql
##syntax: FLOOR(DATEDIFF(DATE(column_end_date), DATE(column_ini_date))/7)
Select FLOOR(DATEDIFF(DATE(20090215), DATE(20090101))/7);
##syntax: FLOOR(DATEDIFF(DATE(column_end_date), DATE(column_ini_date))/7)
Select FLOOR(DATEDIFF(DATE(20090215), DATE(20090101))/7);