I have a table with the date filed entered as INT, so for example 1262817810 as date value.

I'd like to retrieve the rows grouped by day, so I'll need to convert the INT value of my date to a day value, because now every value is different, as it is counted in seconds.

SELECT date FROM revenue GROUP BY DAY(date)
I hope I my make my question clear.

All help really apppreciated!