Date Sort

Discussion in 'PHP' started by IGiveMoney, Feb 15, 2009.

0
  1. #1
    I have a date format that is being called from
    a database that is stored like this:

    Mar-19-2007

    I need a quick little function that will sort the dates
    I would either need it to either be ASC or DESC

    Just I need to get it to sort.

    Any help is appreciated.
     
    IGiveMoney, Feb 15, 2009 IP
  2. bartolay13

    bartolay13 Active Member

    Messages:
    735
    Likes Received:
    14
    Best Answers:
    1
    Trophy Points:
    98
    #2
    doesnt the default "sort by date ASC/DESC" works?
    i think you should convert the Month there first, anyways if you're storing date to the database the best if its all numeric.
     
    bartolay13, Feb 16, 2009 IP
  3. ads2help

    ads2help Peon

    Messages:
    2,142
    Likes Received:
    67
    Best Answers:
    1
    Trophy Points:
    0
    #3
    Maybe you should them in timestamp form, which is all numbers.

    Then, you can sort them easily.

    :: ads2help
     
    ads2help, Feb 16, 2009 IP