select query between date in Android SqliteIs there a way to run Python on Android?How to save an Android Activity state using save instance state?Close/hide the Android Soft KeyboardWhy is the Android emulator so slow? How can we speed up the Android emulator?Improve INSERT-per-second performance of SQLite?What is the difference between “px”, “dip”, “dp” and “sp”?What are the best practices for SQLite on Android?Is there a unique Android device ID?What is the difference between gravity and layout_gravity in Android?Proper use cases for Android UserManager.isUserAGoat()?

How would you control supersoldiers in a late iron-age society?

What does this Blight Tower UI mean?

Other than good shoes and a stick, what are some ways to preserve your knees on long hikes?

Pronunciation of "солнце"

Seven Places at Once - Another Google Earth Challenge?

What are the typical trumpet parts in classical music?

Why does JavaScript convert an array of one string to a string, when used as an object key?

Amortized Loans seem to benefit the bank more than the customer

Very lazy puppy

How do we know that black holes are spinning?

How to draw a Venn diagram for X - (Y intersect Z)?

How To Make Earth's Oceans as Brackish as Lyr's

Exam design: give maximum score per question or not?

Hobby function generators

Can a business put whatever they want into a contract?

Is there a generally agreed upon solution to Bradley's Infinite Regress without appeal to Paraconsistent Logic?

What is the source of "You can achieve a lot with hate, but even more with love" (Shakespeare?)

Asked to Not Use Transactions and to Use A Workaround to Simulate One

What's the benefit of prohibiting the use of techniques/language constructs that have not been taught?

Teleport everything in a large zone; or teleport all living things and make a lot of equipment disappear

Python web-scraper to download table of transistor counts from Wikipedia

How to ensure that neurotic or annoying characters don't get tiring on the long run

What does the "capacitor into resistance" symbol mean?

Output a Super Mario Image



select query between date in Android Sqlite


Is there a way to run Python on Android?How to save an Android Activity state using save instance state?Close/hide the Android Soft KeyboardWhy is the Android emulator so slow? How can we speed up the Android emulator?Improve INSERT-per-second performance of SQLite?What is the difference between “px”, “dip”, “dp” and “sp”?What are the best practices for SQLite on Android?Is there a unique Android device ID?What is the difference between gravity and layout_gravity in Android?Proper use cases for Android UserManager.isUserAGoat()?






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








0















Table



Above is My data screenshot. I need to select catalog if it ranges between the from date and to date. My query is "select catalog from hhItemDiscountOne where fromDate >= '20190305' and toDate <= '20190305'". But i didn't get values even though the date is between the range.










share|improve this question






























    0















    Table



    Above is My data screenshot. I need to select catalog if it ranges between the from date and to date. My query is "select catalog from hhItemDiscountOne where fromDate >= '20190305' and toDate <= '20190305'". But i didn't get values even though the date is between the range.










    share|improve this question


























      0












      0








      0








      Table



      Above is My data screenshot. I need to select catalog if it ranges between the from date and to date. My query is "select catalog from hhItemDiscountOne where fromDate >= '20190305' and toDate <= '20190305'". But i didn't get values even though the date is between the range.










      share|improve this question














      Table



      Above is My data screenshot. I need to select catalog if it ranges between the from date and to date. My query is "select catalog from hhItemDiscountOne where fromDate >= '20190305' and toDate <= '20190305'". But i didn't get values even though the date is between the range.







      android sqlite






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Mar 28 at 12:53









      SureshSuresh

      4613 silver badges11 bronze badges




      4613 silver badges11 bronze badges

























          1 Answer
          1






          active

          oldest

          votes


















          1
















          This is a mistake I often make on first sight. You are mixing the from and to conditions.



          There is no entry with a fromDate >= '20190305', they are both '20190301' which is smaller. So if you are searching values where the date is in the range, your condition needs to be



          fromDate <= '20190305' and toDate >= '20190305' 


          The <= and >= are turned






          share|improve this answer
























            Your Answer






            StackExchange.ifUsing("editor", function ()
            StackExchange.using("externalEditor", function ()
            StackExchange.using("snippets", function ()
            StackExchange.snippets.init();
            );
            );
            , "code-snippets");

            StackExchange.ready(function()
            var channelOptions =
            tags: "".split(" "),
            id: "1"
            ;
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function()
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled)
            StackExchange.using("snippets", function()
            createEditor();
            );

            else
            createEditor();

            );

            function createEditor()
            StackExchange.prepareEditor(
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader:
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/4.0/"u003ecc by-sa 4.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            ,
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            );



            );














            draft saved

            draft discarded
















            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55398181%2fselect-query-between-date-in-android-sqlite%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            1
















            This is a mistake I often make on first sight. You are mixing the from and to conditions.



            There is no entry with a fromDate >= '20190305', they are both '20190301' which is smaller. So if you are searching values where the date is in the range, your condition needs to be



            fromDate <= '20190305' and toDate >= '20190305' 


            The <= and >= are turned






            share|improve this answer





























              1
















              This is a mistake I often make on first sight. You are mixing the from and to conditions.



              There is no entry with a fromDate >= '20190305', they are both '20190301' which is smaller. So if you are searching values where the date is in the range, your condition needs to be



              fromDate <= '20190305' and toDate >= '20190305' 


              The <= and >= are turned






              share|improve this answer



























                1














                1










                1









                This is a mistake I often make on first sight. You are mixing the from and to conditions.



                There is no entry with a fromDate >= '20190305', they are both '20190301' which is smaller. So if you are searching values where the date is in the range, your condition needs to be



                fromDate <= '20190305' and toDate >= '20190305' 


                The <= and >= are turned






                share|improve this answer













                This is a mistake I often make on first sight. You are mixing the from and to conditions.



                There is no entry with a fromDate >= '20190305', they are both '20190301' which is smaller. So if you are searching values where the date is in the range, your condition needs to be



                fromDate <= '20190305' and toDate >= '20190305' 


                The <= and >= are turned







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Mar 28 at 12:57









                ChristianChristian

                3,4411 gold badge18 silver badges28 bronze badges




                3,4411 gold badge18 silver badges28 bronze badges





















                    Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.







                    Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.




















                    draft saved

                    draft discarded















































                    Thanks for contributing an answer to Stack Overflow!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid …


                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.

                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function ()
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55398181%2fselect-query-between-date-in-android-sqlite%23new-answer', 'question_page');

                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    How to preserve electronics (computers, tablets and phones) for hundreds of years Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) The network's official Twitter account is up and running again. What content…How might modern humans leave a message for 50,000 years?How would an aquatic race develop computers?How do we make computers care for human life?Keeping supplies for 1000 yearsWhat will cell phones become in 100 years?What body armor protects against a laser?Could a society attain 1800s technology if limited to using copper and bronze?Electricity power (magic) and electronicsScavenging metal resources in post-apocalypse after 100 yearsWhy would precursors create devices that can survive and still work after hundreds of years?

                    155 수학 과학 기타 둘러보기 메뉴eh추가해eh문서를 완성해

                    Convert JSON to MapSimplest way to convert a string representing JSON array into Java array List of key value pairsHow to take String JSON values into HashMapConvert a JSON String to a HashMapCreating BSON object from JSON stringJSONObject - How to get a value ?Better Map ConstructorReading JSON from Url javaUpdate columns if input values are not null otherwise ignore and keep the existing values of column in databaseHow to store object represented as Json string into Couchbase Lite?Go JSON into MapHow do I efficiently iterate over each entry in a Java Map?Sort a Map<Key, Value> by valuesHow to round a number to n decimal places in JavaCan comments be used in JSON?How do I read / convert an InputStream into a String in Java?How can I pretty-print JSON in a shell script?What is the correct JSON content type?How can I deserialize JSON to a simple Dictionary<string,string> in ASP.NET?Why does Google prepend while(1); to their JSON responses?Parse JSON in JavaScript?