sql - Android SQLite not selecting date -

-

i have sqlite database in app stores date in format of yyyy-mm-dd hh:mm:ss

i love query transaction happend on month of of year code not working don't know why. query shown below, please advice.

select count(id_sale) total_transactions,sold_to,  strftime('%m', sale_date) month,  strftime('%y', sale_date) year, sale_date sales   month=5 , year=2015

after research discovered reason had casting work. here answer below. down vote anyway.

    select count(id_sale) total_transactions,sold_to, cast(strftime('%m', sale_date) integer) month,      cast(strftime('%y', sale_date) integer) year,     sale_date sales   month=5

Comments

Post a Comment

Popular posts from this blog

php - Hide output during test execution -

-
i have var_dumps in php code (i understand there must none in end, still), , while tests running outputs non necessary information console, there method ignore code execution? i've tried /** * @codecoverageignore */ and // @codecoverageignorestart print '*'; // @codecoverageignoreend but ignores coverage, , still executes code. you can set setoutputcallback nothing function. effect suppress output printed in test or in tested class. as example: namespace acme\demobundle\tests; class nooutputtest extends \phpunit_framework_testcase { public function testsuppressedoutput() { // suppress output console $this->setoutputcallback(function() {}); print '*'; $this->assertfalse(false, "don't see *"); } } you can find reference in doc hope help
Read more

java - Drawing vector images on PDF with PDFBox -

-
i draw vector image on pdf apache pdfbox. this code use draw regular images pdpage page = (pdpage) document.getdocumentcatalog().getallpages().get(1); pdpagecontentstream contentstream = new pdpagecontentstream(document, page, true, true); bufferedimage _previmage = imageio.read(new fileinputstream("path/to/image.png")); pdpixelmap previmage = new pdpixelmap(document, _previmage); contentstream.drawxobject(previmage, prevx, prevy, imagewidth, imageheight); if use svg or wmf image instead of png, resulting pdf document comes corrupted. the main reason want image vector image png or jpg image looks horrible, think gets somehow compressed looks bad. vector images shouldn't happen (well, when export svg paths pdf in inkscape doesn't happen, vector paths preserved). is there way draw svg or wmf (or other vector) pdf using apache pdfbox? i'm using pdfbox 1.8, if matters. i this, not directly. in first transform svg documents in pdf documents ...
Read more

javascript - Migrate custom AngularJS filter from 1.2.28 to 1.4.x -

-
i have complex json response iterated on using ng-repeat. relatively small subset of attributes within result set displayed on screen, filtering of results should restricted values user can see, otherwise filtering behavior confusing end-user. since 1 of attributes wish filter on nested array, custom filter needed since built-in angularjs filterfilter not iterate on array elements best of knowledge. i able working time in angularjs v1.2.28, unfortunately appears break during migration v1.4.3. have not spent time isolate in release cadence functionality broke however. i have not found helpful information in migration guides indicate has changed. know actual/expected parameters filter receive different values in latest major version of angularjs, leads failure. ng-repeat filter expression: <li ng-repeat="user in users | list_filter:{establishment: {id: filtertext, names: [{name: filtertext}], locations: [{streetaddress1: filtertext, streetaddress2: filtertext, city:...
Read more