Need help printing formatted mysql datetime field

[eluser]Zeeshan Rasool[/eluser]
[quote author="Yorick Peterse" date="1241286387"]As stated by others, using a correctly formatted date that's being retrieved from MySQL is better. Probably the best way, or atleast my favourite way, is to store an Unix timestamp as the date in your MySQL table and then use the mdate() function to create a date in a specified format, for example:

Code:

<?php
echo mdate("%d-%m-%Y",$row->date);
?>

In this case $row->date fetches the Unix Timestamp from the MySQL database.[/quote]

Well this is also a good method to get date....