select with DATE_FORMAT( )

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
Dear all

I'm quite new to mysql. My aim is to select a date format field by
returning only the month and day number of it (e.g. date = 11 12). I
got this statement and I could not get out how to get rid of the

SELECT `email`, `raum`, DATE_FORMAT('date',`%c %d`) as date FROM

#1054 - Unknown column '%c %d' in 'field list'

Is there a way to mascade `%c %d` so that mysql does not get it as a

thanks in advance   doc scsi

Re: select with DATE_FORMAT( )

On Nov 11, 4:55 pm, wrote:
Quoted text here. Click to load it

Yeah -- don't enclose it in backticks.  It's a string, not a column
name.  Use single quotes instead.

Re: select with DATE_FORMAT( ) wrote:
Quoted text here. Click to load it

For MySQL questions, ask in a MySQL newsgroup - such as  

This newsgroup is for PHP questions.

Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.

Site Timeline