2 messages in com.mysql.lists.javaRe: Parse Error when formatting a date
FromSent OnAttachments
Lawrence Riungu02 Feb 2000 20:16 
John Raab03 Feb 2000 09:27 
Subject:Re: Parse Error when formatting a date
From:John Raab (jra@affinity.net)
Date:02/03/2000 09:27:24 AM
List:com.mysql.lists.java

Here is an example of me using it successfully

date_format(from_unixtime(timestamp), \"%m/%d/%Y\")

Well the from_unixtime might help you, as well as escaping those quotes your using.

-John Raab

----- Original Message ----- From: Lawrence Riungu <lari@cs.vassar.edu> To: <ja@lists.mysql.com> Sent: Wednesday, February 02, 2000 8:16 PM Subject: Parse Error when formatting a date

Hi Does anyone know how to format dates output from Mysql? for example I am using the following line:

.... $query .= "DATE_FORMAT(Updated, "%m%/%d%/%y %r") as nice_updated,"; ....

with the aim of formatting the date to look as follows: 02/02/00 11:48 PM but I get a parse error. I am using PHP3. Does anyone have a clue as to what I may be doing wrong?

thanks,

-L

--------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail java@lists.mysql.com

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail java@lists.mysql.com instead.