> Would it be possible to "GROUP BY " day, when the date-format is in > Unix-time (sec since 1970) ? you can do this: select ... ,TO_DAYS(timestamp) as date_day where ... group by date_day i think? i know that works with a mysql timestamp - don't know if it works with a unix timestamp... can anyone clarify? benji. inchima.com