attempting to use DATE_FORMAT function in a SELECT STATEMENT

[Nicole Lallande]

I am trying to format a TIMESTAMP column on output by using the DATE_FORMAT() function:

Can someone tell me why this does not change the format - no error message - just does not do anything?

$sql = "SELECT * from arviContacts WHERE fid=$zz AND DATE_FORMAT(date_rec,'%Y-%m-%d %T');"

I have also tried

$sql = "SELECT *,DATE_FORMAT(date_rec,'%Y-%m-%d %T') from arviContacts WHERE fid=$zz"; and various other permutations which actually result in error messagets.

I think I am missing a basic concept here....

TIA,

Nicole

Resources accessed: mysql manual, MySQL Cookbook, MySQL Reference Manual


--
########################
Nicole Lallande
[EMAIL PROTECTED]
760.753.6766
########################



---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php