MySQL date function

[mythix]

Hi,

I'm having problems with the DATE_FORMAT function in MySQL. I have a date field in a table called tblArticles. I want to format it like: '1st Jan 2002'

I think this is '%D %b %Y'. But when I execute the quesry I get a value of NULL! what is going on? Also is there a way of naming the result of the function for example aclling it fdate or summit. Thanks.

See query below:

SELECT DATE_FORMAT('date', '%D %b %Y'), tblArticles.* FROM tblArticles, tblAType WHERE tblArticles.atid = tblAType.atid AND type != 'nw' AND type != 'fa' ORDER BY date DESC

[Grubilo]

There is an error in your code.
You try to format the string 'date'.
Try to specify field name without the quotes.
just date or full name: table.field

so:
DATE_FORMAT(table.field, '%D %b %Y')
good luck

[mythix]

Thanks, That's mmuch better