SQLite DB


Last Updated:

  1. rikky

    rikky New Member This Topic's Starter

    Joined:
    Nov 22, 2010
    Messages:
    1
    Likes Received:
    0
    Hello all,

    I was doin some android app and have done almost everything but faced a lot prob at end when selecting date in DESC order. it is selecting date in descending order but like this
    22 NOV 2010
    22 NOV 2009
    22 OCT 2010
    22 OCT 2009
    21 NOV 2010
    21 OCT 2010

    instead of
    22 NOV 2010
    21 NOV 2010
    22 OCT 2010
    21 OCT 2010
    22 NOV 2009
    22 OCT 2009

    plz help me to figure out this prob.
     

    Advertisement
  2. Martimus

    Martimus One bite at a time... Moderator

    Joined:
    Jul 9, 2010
    Messages:
    19,535
    Likes Received:
    4,045
    Welcome to the Android Forums!

    If I try to remember back to my undergrad days I'd say that you're doing an alpha sort on the data fields. Try converting and storing the dates as Julian dates and then sorting on the Julian value. You can then convert the date back to Alpha before displaying it.

    Otherwise try posting your question to the Android Developers forum...

    Application Development - Android Forums
     
  3. NightAngel79

    NightAngel79 Bounty Hunter Administrator Moderator

    Joined:
    May 11, 2010
    Messages:
    22,332
    Likes Received:
    7,598
    Welcome to Android Forums!! We're glad to have ya!!
     

Share This Page

Loading...