easier way to do dates?

[Teach]

Hi there!

At the moment, we are echoing out dates for our database to show joined dates, and various other things. In MySQL our dates are stored as yyyy-mm-dd, but as we're in the UK the normal way is dd-mm-yyyy, so globally we're having to use things such as:

 $date1=substr($user['joined'],8,2)."/".substr($user['joined'],5,2)."/".substr($user['joined'],0,4);

to echo them out properly.

Is there an easier way to make it do this itself rather than each time we want to show a date? Seems like unncessary code...

Thanks!

[bogu]

date('%d-%m-%Y',strtotime($user['joined']));

[rincewind456]

Or you could use the mysql DATE_FORMAT() in the query like :

SELECT DATE_FORMAT('date_field_name_here', '%d %m %Y') AS the_date;