android - Sum over values by month in milliseconds -
I have the table with the price and date from 1970 to integer and the date is
Value in the integer in
millisecond ... I need to get the amount (value) for each month and how do I do any idea with the date in milliseconds? possible? Thank you.
My Table "Entry"
Amount | Date ---------------------------- 300 139 0075200000 150. 13 9 0132500000 20 | 13 9 1075200000 ... | .............
What do I have to achieve:
01.2014 | 450 02.2014 | 20 ....
You must be in the dates so that you are month: Select month as SM (Value) as the sum of the entry group as 1 (*% Y-% m ', Date / 1000,' UnixPok ') < / Ex>
Comments
Post a Comment