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

Popular posts from this blog

c++ - Cmake produces file extensions in static library archives -

-
I have recently switched to autotools to cement, since the limiter cross platform is better for development and what I saw When I build a stable library of my C ++ code, all the files inside .cpp.o is a suffix ar income tax PA8 / libgenericTZR.a genericTZR.cpp.o I have seen other libraries made by other tools and they do not do it, I'm not sure this is the realm And there is a bad thing, but how can I create static libraries without cpp file extension? This is my CMake file add_executable (PA8 ISP_Charges.cpp genericTZR.cpp genericTZR.h) set (LIBSRC genericTZR.c genericTZR.h) add_library (genericTZR shared $ {LIBSRC}) add_library (genericTZR shared $$ TARGET_OBJECTS: myObjects & gt;) install add_library (Generic TZR-static static $ {LIBSRC}) set_target_properties (Generic TZR-Static Properties OUTPUT_NAME $ install (TARGETS PA8 DESTINATION BIN) TARGETS GENICTZR GENERICTZR-STATIC DESTINATION lib) Installed (files "$ {PROJECT_BINARY_DIR} /PA8/genericTZR.h...
Read more

c# - Roxy file manager in MVC doesn't accept session path -

-
Hi friends I've downloaded a file manager for my MVC project. So I added to my project and everything works fine but everyone can use this product I mean everyone can type urls and upload files to my host !!!! This filemanager has a Jason config file, as you can see here: {"FILES_ROOT": "Fileman / Upload "," "File_type_kenny": "file", "THUMBS_VIEW_WIDTH": "140", "THUMBS_VIEW_HEIGHT": "120", "PREVIEW_THUMB_WIDTH": "300", "PREVIEW_THUMB_HEIGHT": "200", "MAX_IMAGE_WIDTH": "0" "ASP_net / Main.Shex? A = Created", " Dealederer ":" ASP_net / MAN.assx "ADELEDED IR "," MOVEDIR ":" ASP_net / Main.Shex? A = MoVEDIR "," Copdier ":" ASP_net / Main.Shex? A = Copdier "," Richie Dar ":" ASP_net / Main ASP_net / main.hex? A = Upload "," Downlo...
Read more

c# - Check if a NumericUpDown has no value -

-
How can I check that the user left a NumericUpDown control blank? I have looked at another question to examine the 'text' property but there is no text property to check against it. You can check against the text property, though it is a designer and Is hidden from Intelligence. Just try this sample it works: if (string.IsNullOrEmpty (control.Text)) {// a value}
Read more