Normallly to format a date when pulling it from MySQL, i would do the following
Code: Select all
SELECT *, DATE_FORMAT(pi_date, '%d-%m-%Y') AS display_date......Is there another way to do it within the query, or would it be better creating a PHP function to format the date after it has been pulled from the DB?
Cheerz
Mark