Converting time stamp to 'normal' date function

[bladechob]

Hi, I'm looking for a bit of code/formulae to convert unix time stamp info into a conventional date format. I have a file that generates invoices from data requested from an sql table - trouble is it brings in the date as a timestamp. I'm looking for something I can plug into the php invoice file rather than altering the database.

 

Thanks

[Jessica]

http://php.net/date

[jitesh]

<?php

$unix_timestamp = mktime();
echo date("Y-m-d h:i:s",$unix_timestamp);
?>