Find last 10 days records even some days is missing between
(adsbygoogle = window.adsbygoogle || []).push({ google_ad_client: "ca-pub-2506679117428139", enable_page_level_ads: true });
Here I'm selecting last 10 days records from transaction table even there is some days has no any transaction.
SELECT * FROM `transaction` `t` WHERE DATE(`t`.`timestamp`) < ( SELECT DATE(`s`.`timestamp`) FROM `transaction` `s` GROUP BY DATE(`s`.`timestamp`) ORDER BY DATE(`s`.`timestamp`) DESC LIMIT 10,1 ) ORDER BY `t`.`timestamp` DESC
SAMPLE: Results will be only for previous date:
/*<![CDATA[*/ var getDate = function(interval) { now = (new Date).getTime(); if(!interval) { interval = 0; } var today = new Date(now + interval), yyyy = today.getFullYear(), mm = today.getMonth() + 1, dd = today.getDate(); if(mm < 10) { mm = '0' + mm; } if(dd < 10) { dd = '0' + dd; } return yyyy + '-' + mm + '-' + dd; } var interval = 86400000; document.write(getDate(interval * -1) + ' '); document.write(getDate(interval * -2) + ' '); document.write(getDate(interval * -4) + ' '); document.write(getDate(interval * -7) + ' '); document.write(getDate(interval * -8) + ' '); document.write(getDate(interval * -9) + ' '); document.write(getDate(interval * -11) + ' '); document.write(getDate(interval * -12) + ' '); document.write(getDate(interval * -13) + ' '); /*]]>*/