SQL statement
| From: | Dan J. Rychlik | Date: | Tue, 23 Sep 2003 23:58:28 +0000 |
| Subject: | SQL statement | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-163655@lists.php.net to get a copy of this message | ||
Hello,
Im having a bit of trouble with the DATE_FORMAT function in mysql.
$query = ('SELECT username, password, DATE_FORMAT(timestamp, '%d%m%y') FROM
custlogon');
I know its failing because php doesnt like the quotation before the format parameters. Ive tried to
fix this without any luck. Any Ideas ?
DATE_FORMAT ( timestamp, ' %d%m%y ')
Thanks in advance,
-Dan