|
|
Posted by Jerry Stuckle on 11/11/07 22:50
docscsi@googlemail.com wrote:
> 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
>
>
For MySQL questions, ask in a MySQL newsgroup - such as
comp.databases.mysql.
This newsgroup is for PHP questions.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|