Posted by cosmoKen on 04/12/06 18:28

Yes, dates in MySQL are stored in the format YYYY-MM-DD
To get a readable format, you have to convert it.

The simplest way is to use :
echo date('d/m/Y H:i', strtotime($row['DATE']));

But you can use the ereg way to be sure of your result. The date
conversion is one of the manual examples of the function ereg
http://www.php.net/ereg

[Back to original message]