dateline Parsing Function

[PMichaud]

Hey all,

I don't know how the dateline column in the post table is formatted. Is there an available function I could use to plug in the dateline int, and get back a pretty date and time string?

Thanks!

[PMichaud]

Alright, I've solved my own problem -- dateline is a unix time stamp, so I can just use date() on it. However, I still have an issue...

I'm not sure how to write a mySQL query that says to return thread only past a certain date? I know they have a function that allows you to simply specify, but I need the actual sql query for my purposes.

How would I take a timestamp and detect whether it was from, for example, 30 days or sooner?