Format Date?

[eluser]mironcho[/eluser]
Hi Jauhari,
Other possible solution is to use MySQL DATE_FORMAT() function in your sql code:

Code:

SELECT DATE_FORMAT(your_date_field, 'Year: %Y Month: %m Day: %d') AS formated_date FROM your_table;

If you prefer to format it in php - probably strtotime will be faster than mysql_to_unix.