actually, it isn't
internal storage formats are completely unrecognizable (if you were ever able to see them, which you can only do by reading the actual physical storage files yourself)
also, "past 30 days" is not the same as "past month"
it is the difference between 2008-10-13 to 2008-11-13 and 2008-10-01 to 2008-10-31
tripy, don't forget that if you do this --
date(newsDate) >= date(now()-interval 30 day)
then by putting a function on the column, you're forcing the optimizer into a table scan because it can't use an index on the column