mysql date format to other

[jeanloui]

How to change the 2003-09-26 mysql date format to 26-09-03?

I have tried:

$result = mysql_query("SELECT * FROM clips WHERE section=$id",$db);

while ($row = mysql_fetch_array($result))
{
	$id = $row["id"];
	$mysql_date =$row["date"];
	$date = mysql_query ("SELECT DATE_FORMAT ($mysql_date, '%d-%m-%y');");
}

but it does not work 🙁
I know that there is a direct way for doing that, but I don't remember how.

Thanks!

[bad76]

Hi,
you can do this in two way:

first, in php way:

$result = mysql_query("SELECT * FROM clips WHERE section=$id",$db); 

while ($row = mysql_fetch_array($result)) 
{ 
    $id = $row["id"]; 

$date = explode("-",$row["date"]);
$date = $date[2]."-".$date[1]."-".$date[0];
}

second, in mysql way:

$result = mysql_query("SELECT *, DATE_FORMAT(date, '%d-%m-%y') as ddate FROM clips WHERE section=$id",$db); 

while ($row = mysql_fetch_array($result)) 
{ 
    $id = $row["id"]; 
    $date = $row["ddate"];
}

Be care: i've looked "DATE_FORMAT(" work, but "DATE_FORMAT (" no ( with blank before "("... )

see you

[jeanloui]

Be care: i've looked "DATE_FORMAT(" work, but "DATE_FORMAT (" no ( with blank before "("... )

Thanks! I'll try the php way first (is the one I understand the best).

It begin to work with this:

$mysql_date = $row["date"];
$frag = explode("-",$mysql_date);

$array = array ($frag[2], $frag[1], $frag[0]);
$date = implode ("/", $array);

I don't know if the mysql way will work, cause the table "clips" has fields that are not Dates!

I'll mark as resolved when it works

But the "php way" gives "26-09-2003" instead of "26-09-03"... Now with some php string operation, perhaps I can isolate the last 03 from 2003...

Thanks again!