date stamp difference

Anon

Hello all,

Ok my issue, I have 2 time stamps.
$now which is 2000-11-07
and
$then which could be anything. (same format)
all i want to do is see if the diff is greater than 90 days
why is this killing me? 🙁

ill take any help
thanks

pete

Anon

I saw where someone answered this already for a PHP solution. Are you selecting these two timestamps out of a mysql database? if so, there's a simple way to do it in your actual query.

SELECT now,then,TO_DAYS(then) - TO_DAYS(now) AS diff FROM your_table

or, if now is always '2000-11-07', then use:

SELECT then,TO_DAYS(then) - TO_DAYS('2000-11-07') AS diff FROM your_table

Then you'll have $diff after you fetch the information.

You can also set up something like this in your where clauses to only select rows that are older than X days, or delete them, or whatever. Let me know if you have any questions, if this is even what you're doing.. 🙂

---John Holmes...

Anon

John,

I see what your talking about with the TO_DAYS function in MySql. BUT for whatever reason when i use the sql statement in PHP i get strange random numbers yet when I use the exact same statement on the command line i get a good TO_DAYS value.?
So I gave up trying to figure it out and have since gone back to doing it in php with the mktime function which works like a charmer.

Any thoughts on the TO_DAYS kink?

thanks

pete

Anon

Hmm..Is this on the same database? Can you print out the sql command in your php program before it's executed? Does it look correct? What kind of column is this, timestamp or date?

Not sure what would cause that except that you might not be creating your query correctly in php...

---John Holmes...

Anon

John,

What i was doing is getting the date out of the database and using that variable in the sql statement. And for what ever reason it was incrementing by 2. In other words the TO_DAYS would print 2 then 4 then six ( inside a while loop (limiting to 90 days))
Now when I cut and paste the same statement into the command line of phpmyadmin I get a good TO_DAYS value.. bizzare unless im missing a big piece of the pie (quite possible :o( )
hummmmm

pete

Anon

It's got to be something in your code that you're missing...can you post it here?

---John Holmes...