date format

[legal-medium]

I have dates stored in a database

name type
age date(8)

Data before conversion(this is what is retrieved via query)
2002-12-13

Data after coversion(this is the result I want)
12-13-2002

I am sure I need to use mktime(), I am not sure how to do this

Thanks

[cgraz]

You could use DATE_FORMAT()

$query = mysql_query("SELECT DATE_FORMAT(date_field, '%c %e %Y') FROM yourtable");

Cgraz

[legal-medium]

I tried and does not seem to be working for me

///////////////////////My Code Begin

$qry = "SELECT location, channel, sport, title, address, DATE_FORMAT(date, '%c %e %Y'), name, phone, description, url
FROM public_events
WHERE id = '$pid'
";
$find = mysql_query($qry, $db) or die (mysql_error());
$data = mysql_fetch_array($find);

///////////////////////My Code End

So the variable is called $data[date] and it returns null

What am I doing wrong?

[cgraz]

Try this:

$qry = "SELECT location, channel, sport, title, address, DATE_FORMAT(date, '%c %e %Y') AS date, name, phone, description, url 
FROM public_events 
WHERE id = '$pid' 
"; 

Cgraz

[legal-medium]

DATE_FORMAT(date, '%c %e %Y') AS date

WORKS

Thanks

[cgraz]

No Problem.

Cgraz