database date format

when i look at the vb3_user table for a vbulletin forum, i notice that the joindate field has values in the form of "1174753712". how do i convert this into a normal human understandable date - e.g. "3-Mar-07"

thanks in advance for any help that you may provide.

 

You might find this helpful : http://www.plus2net.com/php_tutorial/php_date_time.php

 

thanks... anyone else got suggestions?

 

OK let me try again :
Get the data from your database and :

echo date("d-M-y",$datevar);

PHP: