Hi !
If you're using mySql you could use the DATE_FORMAT( colname, sFormat ) function to do the job for you.
Something like
select DATE_FORMAT( colname, "d/m/Y" ) from table;
Or, you can do it in PHP with a regexp replace with this tiny function:
function convertDate( $sDate )
{
return ereg_replace( '([0-9]{4})-([0-9]{2})-([0-9]{2})$', '\3/\2/\1', trim($sDate) );
}
Using mysql to do the job for you is a good thing cause you can have your dates unformatted and untouched and format them pretty much as you like it "on the fly". The bad thing about this implementation is that if you switch to a database that doesen't support date formatting functions or date arithmetics you'll have to rewrite a lot of things. Choose whatever implementation you fund suitable for your current project.
Hope you found this useful !
/ Ronnie
