Simple question about unix epoch

I am learning, but I need some help on a problem I have atm. I am using Invision Board Forums and want to query the db for members on name, total posts, join date, last post, last visit, and email. The problem is join date, last post and last visit come up as unix timestamp and I am not sure how/if I can convert those to standard date format in the query.

Please if anybody could post a solution or the query structure I would appreciate it as this is just a side hobby for me.

Just some info:

db name is members
column names are name, joined, posts, last_post, last_visit, email

use the FROM_UNIXTIME function as follows...

select name, FROM_UNIXTIME(joined,'%m/%d/%Y')as join_date, posts, FROM_UNIXTIME(last_post,'%m/%d/%Y')as last_post, FROM_UNIXTIME(last_visit,'%m/%d/%Y')as last_visit, email from members where ...(put your conditionals here)

This will return the unix timestamps like

01/01/2003

give it a try...

Thank you very much!