SELECT CAST((MessageDate + INTERVAL 9 HOUR) AS DATE) AS Purchase_Date,
ItemCount
FROM table
Works just fine and returns the dates exactly as I want, unfortunately I
need to be using sum(ItemCount) giving me...
SELECT CAST((MessageDate + INTERVAL 9 HOUR) AS DATE) AS Purchase_Date,
sum(ItemCount) AS TotalItems
FROM table
GROUP BY Purchase_Date
And unfortunately as soon as I group on the date it gets mutated into binary
data instead of the date.
Any ideas on why and how to get round it?
--
Jay
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
