Previous Date

[steveangelis]

I have a database with a massive group of entries in it, all with dates.  What I am trying to do is get all of the dates, and this script will be run once a day, that are a year old or older.  Again since this will be run consistantly the data coming out will be ever growing.  My current script is this but it is not working:

 

SELECT * FROM user WHERE lastvisit > (date("U")-315369000)

 

Now that number, 315369000, is how many seconds i has been since a year ago but it is not working.  Does anyone know why and/or how I can get it to work properly?

[steveangelis]

Oh and one other thing.  The field lastvisit is saved as a unixtime field so all of the dates are like this:

 

1251726871

[samshel]

you can calculate the one year old date in PHP by

 

$timstamp = time() - 315369000;

 

And use that time stamp in the query

 

$sql = "SELECT * FROM user WHERE lastvisit > '".$dt."'";

[kratsg]

If you want to be super-picky and check for leap-years and whatnot, try the following:

 

$timestamp = strtotime("-1 year");

 

Note, this isn't tested, but I'm pretty sure it will work.