Results 1 to 9 of 9
Jun 12, 2012, 12:50 #1
- Join Date
- Jun 2004
- 0 Post(s)
- 0 Thread(s)
Order by date when date is int value
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)
All help really apppreciated!