time format (once again, pls)

rebelo

12-29-2003, 02:36 PM

how can i have the output of the following code line:

<td>".$data ["invoice_date"]."</td>

in the d/m/Y format.

Nightfire

12-29-2003, 02:42 PM

How does the date look now?

rebelo

12-29-2003, 03:25 PM

2003-28-12

Nightfire

12-29-2003, 03:49 PM

In your sql query:

$query = "SELECT DATE_FORMAT(invoice_date,'%D/%M/%Y') AS invoice_date";