Menu

#4 Date sorting is numeric and should be "date order"

TyEditor
open
nobody
None
5
2003-03-23
2003-03-23
No

When browsing the now showing list, I clicked on
the "date" header to sort the listing by date (which is the
most like the normal now showing list on the tivo). I
found it sorted numericly when it should have stayed in
a date order.

For example, it did this:
1/3/03
13/3/03
2/3/03

when it should have done:
1/3/03
2/3/03
13/3/03

A fix could be kludged by padding out the single digit
entirys with a zero. That way the come out proper in a
normal numeric sort. For Example:
01/03/03
02/03/03
13/03/03

Of course to be truely sorted properly it would need to
be year/month/day order.

Discussion

  • Nobody/Anonymous

    Logged In: NO

    Same problem with FSID which is treated as a string instead of a long integer. I have 5 and 6 digit FSIDs which do not sort correctly.

    David

     
  • Steven Adeff

    Steven Adeff - 2003-04-23

    Logged In: YES
    user_id=432641

    bump, this is a rather annoying "bug"

     
  • Nobody/Anonymous

    Logged In: NO

    This is called CHARACTER sorting... Not Numeric...
    Numeric/Date sorting is what is needed. This happens
    because to the computer 1 and 1 are alphabetically the same
    thing. Padding it with zeros works because 0 comes before 1
    in the computer alphabet.

     

Log in to post a comment.

MongoDB Logo MongoDB