MYSQL doesn't return proper results
I have a strange problem with a v bulletn forum that I run. I'm trying to select all threads that are older than a certain date. I looked up the mysql syntax for the query and got:
SELECT * FROM `thread` WHERE dateline < (NOW() - INTERVAL 12 MONTH)
I could use any interval and I get the same result of only one record where there isn't any date inserted, just a zero. The database uses a unix time stamp. Trying every variation doesn't seem to return results. In the above query, thread is a table with a bunch of fields and dateline is one of them that has the unix timestamp. I am guessing that perhaps the query doesn't work with unix timestamps and perhaps must be converted into a different format in order to make use of the mysql functions.