In ColdFusion you would use the date format function

#DateFormat(CreateODBCDate(yourDate), "dd/mm/yyyy")#

For more information on this do a Google search on: ColdFusion date format function

In PHP

date("Y/m/d")

For more info on this do a Google search on: php date format function

--
Lawrence   *Adobe Community Expert*
www.Cartweaver.com
Complete Shopping Cart Application for
Dreamweaver, available in ASP, PHP and CF
www.twitter.com/LawrenceCramer

By the way, the answer to this question was in Formatting dates stored in MySQL in the Dreamweaver FAQ.

That makes no difference. Just write your SQL so that it includes the DATE_FORMAT() and alias.

If you're being incredibly lazy, you can do this:

SELECT *, DATE_FORMAT(start) AS start_date
FROM my_table

Interesting.. both of your suggestions return errors claiming that there are too few arguments, resulting in an empty query.

Yes, there were too few arguments in the second example. It should be this:

SELECT *, DATE_FORMAT(start, '%m/%d/%Y') AS start_date
FROM my_table

Make sure you use single quotes around the '%m/%d/%Y'.

That should work. What happens when you use SELECT joindate FROM member?

The alternative way to do it is to create a small PHP function like this:

function format_mysql($date) {
  $parts = explode('-', $date);
  if (is_array($parts) && count($parts == 3)) {
    return "$parts[1]/$parts[2]/$parts[0]";
  } else {
    return 'Date not available';
  }
}

Then display the result from your recordset like this:

<?php echo format_mysql($row_recordsetName['joindate']); ?>

There's something wrong with your code somewhere. I have just run the following test code, and it displays '02/01/1993', exactly as I expected it would.

<?php
function format_mysql($date) {
  $parts = explode('-', $date);
  if (is_array($parts) && count($parts == 3)) {
    return "$parts[1]/$parts[2]/$parts[0]";
  } else {
    return 'Date not available';
  }
}
$test = '1993-02-01';
echo format_mysql($test);
?>