Posted by docscsi on 11/11/07 21:55

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
error:

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

#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
field?


thanks in advance doc scsi

[Back to original message]