android - get week number of a date -

- 

select strftime('%w', day) week, sum(amount) mytable group week order week desc

this query useful amount week. 1 gives week number in year, may know how week number in month. have googled lot. results related week number in year not in month.

thanks in advance.

you can manipulate strftime() answer.

apply strftime() on given date , first date of given dates month , subtract them week number of month

eg

 select  strftime('%w','2013-05-04')-strftime('%w','2013-05-01') +1;

sql fiddle demo


Comments

Post a Comment

Popular posts from this blog

objective c - Can't build GCM with Protobuf in Xcode -

-
recently i've decided integrate gcm project uses google protocol buffers. worked fine, sample ok. when i've tried integrate gcm via cocoapods project - started receiving build errors: undefined symbols architecture x86_64: "_gsdk_pblogicalrightshift32", referenced from: _serializedsize in libgcmlib.a(gcmsecuresocket.o) "_objc_class_$_gsdk_pbcodedoutputstream", referenced from: objc-class-ref in libgcmlib.a(gcmsecuresocket.o) "_objc_class_$_gsdk_pbdescriptor", referenced from: objc-class-ref in libgcmlib.a(gtalkcore.pb.o) objc-class-ref in libgcmlib.a(gtalkextensions.pb.o) "_objc_class_$_gsdk_pbgeneratedmessage", referenced from: _objc_class_$_gtalkheartbeatping in libgcmlib.a(gtalkcore.pb.o) _objc_class_$_gtalkheartbeatack in libgcmlib.a(gtalkcore.pb.o) _objc_class_$_gtalkerrorinfo in libgcmlib.a(gtalkcore.pb.o) _objc_class_$_gtalksetting in libgcmlib.a(gtalkcore.pb.o) _objc_class_$_gtalkloginrequest in libgcmlib.a...
Read more

Winapi c++: DialogBox hangs when breaking a loop -

-
i've created s simple w32 application cicle through 2 applications(hard coded window classes atm). when call start button (idc_start) works fine, when change focus hwnd application hangs cannot closed. need simple , clean method stop loop, start when calling idc_start. apreciated! #include <stdio.h> #include <stdlib.h> #include <conio.h> #include <windows.h> #include <resource.h> #include <iostream> using namespace std; bool callback dlgproc(hwnd hwnd, uint message, wparam wparam, lparam lparam) { hwnd hwnd1,hwnd2; hwnd1 = findwindow("notepad++",0); hwnd2 = findwindow("notepad",0); bool bdone; switch(message) { case wm_initdialog: // set dialog box, , initialise default values { setdlgitemint(hwnd, idc_number, 5, false); hicon hicon, hiconsm; hicon = (hicon)loadimage(null, "e32.ico", image_icon, 32, 32, lr_loadfromfile); if(hicon) se...
Read more

How to use function view in Drupal -

-
hi guys new drupal bare me :) . i trying lear how create own module , stuck. created text.module, text.install , text.info . it's basic module inputing text. so have next scenario iput text in textbox saves table in database can display table in : http://img33.imageshack.us/img33/5815/textyi.jpg now question can , how can use function view in picture "ttt" becomes link can see title , text "ttt" ? edit : i figure out need : in table have 3 columns (test_id, title, text) now use $result = db_query("select title,text {text} "); now how can turn title link . let in row 1 col1 of title stands house. how can turn house link. need sometning $result= db_query ("select n.title, n.text form {text} n n.title = :title", array (":title" => ???? )) i think looking for <?php l(t('link text'), 'about-us', array('attributes' => array('class' => 'about-link')));...
Read more