Output last x amount of saved datatables from sql from saved timestamp

Question

I have a datatable that saves created data as : user.createddate

Every time I add to the datatable, it saves as such for this data(timestamp) :

2016-02-02 09:10:26

What would be the best way for me to parse the timestamp, and only display results that are "x" old?

I added the following per suggestion, but it still does not parse correctly :

$cond = 'WHERE user.createddate >= DATEADD(day,-7, GETDATE())';

@Eugen helped me out in the comments. Basically, user.createddate has the entire datetime that needs to be seperated first to give me an approximation to work with in days previous, using the following code you can do as such :

$sql = "SELECT 
                * 
            FROM 
                ".$table." 
            WHERE 
                DATE(edit_date) = DATE_SUB(CURDATE(), INTERVAL 7 DAY)
            ";  
    return $sql;

I will mark you as best answer, if you post as actual answer. Thanks!

I already have it saving the data as it is needed, how would I display the most recent database additions within the selected timeframe? — Steven, Dec 26 '16 at 21:23
`SELECT * FROM WHERE date >= ‘firstdate’ AND date < ‘seconddate’` — Eugen, Dec 26 '16 at 21:28
that would work perfect, but it would have to be something like this : WHERE user.createddate >= 5daysprevious of currentdatetime — Steven, Dec 26 '16 at 21:29
look here http://stackoverflow.com/questions/7756708/mysql-select-rows-from-exactly-7-days-ago — Eugen, Dec 26 '16 at 21:34

score 0 · Answer 1 · answered Dec 26 '16 at 21:36

0

Use MySQL functions: NOW, DATE_SUB and INTERVALL

user.createddate BETWEEN DATE_SUB(NOW(), INTERVAL 7 DAY) AND NOW()

answered Dec 26 '16 at 21:36

Ben Smith

76
5

msh · Answer 2 · 2016-12-27T05:52:36.493

-1

use this line : this work correctly :) echo time_elapsed_string('2016-02-02 09:10:26');

edited Dec 27 '16 at 05:52

answered Dec 26 '16 at 21:27

msh

31
3

Output last x amount of saved datatables from sql from saved timestamp

2 Answers2