Posts by Edmilson Duarte • 1 point
1 post
-
-2
votes2
answers1627
viewsA: Fetch data from last 7 days from current date (2014-12-11 11:06:09)
Do so: SELECT * FROM sua_tabela WHERE seu_campo BETWEEN date(date(now()) - 7) and date(now());
1 post
-2
votes2
answers1627
viewsDo so: SELECT * FROM sua_tabela WHERE seu_campo BETWEEN date(date(now()) - 7) and date(now());