How do you compare two unix date mysql columns in a query?
Posted on 2011-02-14
I have my query set that displays the columns/data that i want from multiple tables
two of the columns that are displayed are
"test_time" and "test_time2"
those time columns are in UNIX time
now i would like to compare those two columns... test_time is always going to be older in time than test_time2.
have a column added to the query that displays the time difference.
Then i would like to display or get a row count of how many of those comparisons are with in 24 hour difference.
for an added extra bonus.. how can i display a percentage of those are within 24 hours.
Any help would be awesome!! i love EE!!