defining DATE format on html output

[Wreck-It]

I've seen a couple of threads on this, but just don't get it...

I have a page to display query results on a table, and want to display the date according to european standards, that is DD/MM/YYYY.

Here are my current statements:

$f_date = $row["date"];

and

echo "<tr><td style=\"font-weigth:bold;\">Date</td><td width=\"400\">$f_date</td></tr>";

Where and what is the correct syntax?

	:confused:

[dalecosp]

Great kluge here:

$f_date = $row["date"];
$f_date=strtotime($f_date);
$f_date=date("d/m/Y", $f_date);

echo "<tr><td style=\"font-weigth:bold;\">Date</td><td width=\"400\">$f_date</td></tr>";

😃

[Wreck-It]

Thank you very much, dalecosp. This was very helpfull. 🙂

[YappyDog]

$f_date = $row["date"];
$f_date=strtotime($f_date);

Be certain you know what format your $row["date"] is in before you use the strtotime() function.

The function really does an understandably poor job of knowing whether 11/03/2003 is supposed to be Nov 3rd or Mar 11th.

[dalecosp]

Sure. But we're going to assume in this instance that $row['date'] stands for a MySQL formatted DATE field, (ie 2003-11-04 || today).

In that case, the code works, despite its lack of elegance. If I assumed incorrectly in re: his date format, I guess he'll tell us.

Nonetheless, thanks for the pointer.

[dalecosp]

Sure. But we're going to assume in this instance that $row['date'] stands for a MySQL formatted DATE field, (ie 2003-11-04 || today).

In that case, the code works, despite its lack of elegance. If I assumed incorrectly in re: his date format, I guess he'll tell us.

Nonetheless, thanks for the pointer.