Date format in DB for comments

[BrownieScraps]

This isn't truly a 'how do I', though actually more of a question, but I figured this was the most appropriate place to post. If not, I apologize!

I am wanting to be able to query against the pp_comments table in the DB to be able to find things like the highest comment count per user per time period.

(Just FYI - I don't remember if pp_ is part of the default install, or I chose it as the table prefix, but all my PhotoPost tables start with pp_)

In looking at the pp_comments table in the database I'm finding that the 'date' field is actually an int(15) and so I'm wondering what date format this is in so that I can properly convert it to a date to do my queries.

I'm running 6.11.

Thank you in advance.

[Chuck S]

The date format is a unixtimestamp

Unix Timestamp and PHP

[BrownieScraps]

Thank you so much. I had tried searching, but was just getting back garbage and I figured I'd come right to the source.

This will be very helpful.

Thanks again.

[Chuck S]

Have a good weekend.