Using 4.1.3 beta (InnoDB) on XP, via ColdFusion MX
I have a table containing (among other things) a list of dates for soccer
matches to be played. In order to list them correctly, the SQL has been:
SELECT DISTINCT fixturedate,
MONTH(fixturedate) AS CalMonth
FROM Fixtures
ORDER BY
Okay, here's an interesting one. Here's the query:
SELECT distinct date_format(auditdate, %Y%M ) as listUrl, date_format(
auditdate, %Y%m ) as blank
FROM quality_history
WHERE auditdate Now()
ORDER BY listUrl desc
LIMIT 6
auditdate is a DATE datatype
When I run this