[snip]
In a receipt to the customer you might want to show them their date of
order and other information using:
$query=SELECT DATE_FORMAT(o.date, '%m/%d/%Y'),
it.cost
FROM order o, item it
WHERE cust_id = $custId;
To
8:27 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] displaying a MySQL date in a different format
Can anyone help me. I am trying to display a date in a different format from
that stored in a MySQL database. MySQL forces you to store it as -mm-dd
but I want to display it as dd-mm-, or dd-
Can anyone help me. I am trying to display a date in a different format from
that stored in a MySQL database. MySQL forces you to store it as -mm-dd
but I want to display it as dd-mm-, or dd-
Any ideas?
Many thanks in advance
Ali McLeod
[EMAIL PROTECTED]
--
PHP Database Mailing
:
Subject: [PHP-DB] displaying a MySQL
date in a different format
01/04/2003 06:27