Understanding YaBB's date format

[rpoelking]

YaBB SE Version: 1.5.4
PHP Version: 4.3.0
MySQL Version: 3.23.x
Server Platform: Unix, Linux, or BSD
Link to Forum: www.kajukenbocafe.com

Problem Description:
I am trying to manage my member's database a little more intelligently by making sure I don't delete members who just log in to read but never post. I've looked at the two date fields in the DB and they are both stored as BigInt(20). How do I convert that to a date I understand?

[Douglas]

http://www.php.net/time
http://www.php.net/date

Study the first one, since that's the format that it uses (or something similar)

[rpoelking]

That does help but can I do this in MySQL? I'm more familiar with SQL that with PHP.

[[Unknown]]

SELECT FROM_UNIXTIME(posterTime);

-[Unknown]