1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Oracle DATE sorting help

Discussion in 'MySQL' started by saintdw, Oct 14, 2005.

0
  1. #1
    I have a table with following type of data inserted

    DATE ('02-5-2005') i.e. the output of that would be "2-May-05"


    The problem is, when I try to do a ORDER BY date, date being a column with dates, it onle sorts them by first digit, i.e. "2" and doesnt consider month or year.

    What am I doing wrong?
     
    saintdw, Oct 14, 2005 IP
  2. Weirfire

    Weirfire Language Translation Company

    Messages:
    6,979
    Likes Received:
    365
    Best Answers:
    0
    Trophy Points:
    280
    #2
    Have you tried using a timestamp? You can always change the way the date is displayed once you extract the date. I dont know how this is done for Oracle however as I'm more used to MySQL.
     
    Weirfire, Oct 18, 2005 IP
  3. saintdw

    saintdw Peon

    Messages:
    453
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I figured it out.

    When i created table I used varchar2 instead of DATE. :eek:
     
    saintdw, Oct 20, 2005 IP
  4. Weirfire

    Weirfire Language Translation Company

    Messages:
    6,979
    Likes Received:
    365
    Best Answers:
    0
    Trophy Points:
    280
    #4
    :) Thought it might have been something like that.
     
    Weirfire, Oct 21, 2005 IP