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.
I hope I my make my question clear.Code:
SELECT date FROM revenue GROUP BY DAY(date)
All help really apppreciated!