time() to date

[Guest]

I am storing my time in a databse but i want to take it out and show it as a date like 7-12-2007 how can i convert the time() into the date? I dont care about hour minute second i just want the date.

[Wildbug]

In MySQL, use DATE_FORMAT(col,"%m-%d-%Y")

 

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-format

[Caesar]

<?php

$current = time(); //This could also be a timestamp from your database
$time_new = date("m-d-Y", $current);

echo $time_new;

?>