A little help with mySQL and SQL ORDER BY with dates

[MasterMax1313]

I've got an SQL statement

SELECT * FROM MINUTES ORDER BY Mod_Date DESC LIMIT 0, 10;

where Mod_Date is a date data type. as you can probably see what I want to do is sort the output in descending order by date. this however is apparently not the way to do so. so can anyone lend a hand with figuring this out?

 

[bonzo meier]

looks ok to me...

maybe you can post one of your Mod_Date's? just to see what they look like...

and: is the output being re-ordered in any way?

peace, bonzo

 

[MasterMax1313]

(sigh)

you're right bonzo. syntax error on my part when I was looking at the output. it is sorting by Mod_Date just fine. I on the other had was looking at Create_Date.

Thanks for the slap to the cerebrum.