Re: attempting to use DATE_FORMAT function in a SELECT STATEMENT

2002-11-30 Thread Nicole Lallande
hen You fetch mysql result Regards, Robert - Original Message - From: "Nicole Lallande" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, November 30, 2002 11:38 PM Subject: attempting to use DATE_FORMAT function in a SELECT STATEMENT I am trying to fo

attempting to use DATE_FORMAT function in a SELECT STATEMENT

2002-11-30 Thread 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 als