I am trying to get a distinct dates (not time) from a column. I am currently doing this:
SELECT DISTINCT DATE_FORMAT(DateAdded, '%Y-%m-%d') FROM Bla
Is this the best way to be doing this? Seems very inefficient do to the call to DATE_FORMAT for every row. Is there a way to have a query only pay attention to the DATE part of a DATETIME or TIMESTAMP column?
Ron
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
